Re^2: DBI and last_insert

Replies are listed 'Best First'.
Re^3: DBI and last_insert_id by perrin (Chancellor) on Jan 29, 2009 at 16:56 UTC
Ok, here are a couple more thoughts. First, is there possibly another insert in your real code between the first insert and your call to last_insert_id? A side effect of some sub call maybe? Second, you definitely should be able to see data you inserted during a transaction with a SELECT, even if the data is not committed yet, provided your queries are all coming from the same connection. That sounds very suspicious to me.	[reply]
Re^4: DBI and last_insert_id by cog (Parson) on Jan 29, 2009 at 18:17 UTC
... is there possibly another insert in your real code between ... No, the statements are just one after the other and there's no call to any other methods in between. ... you definitely should be able to see data you inserted during a transaction with a SELECT ... I was under that impression too, but didn't think too much of it. Now that I have someone telling me that, I'm going to look into that. Thanks.	[reply]