On Nov 12, 2007 5:24 PM, Yves Goergen <nospam.list@stripped> wrote:
> Damn, I found out that I need table locking *and* transactions.
What makes you say that?
> Maybe I'm really better off using a sequence (like the one PostgreSQL
> offers and like it is available as an add-on for Perl ).
That Perl module uses the exact technique I described to you with
updates and LAST_INSERT_ID().
Frankly, doing the insert and checking for an error seems like a
pretty reasonable solution to me, since you only have two databases to
care about at this point.