Re: [PERL DBI] Insertiing data across multiple tables

JD Wong wrote:
> Does anybody know how to insert data over multiple tables
> transactionally?  The relationship is 1:1 with the latter table having
> a foreign key constraint.  In order to add data to Table2 I need to
> know the primary key value of the same record in Table1 before it's
> committed, which in this case is a serial integer which of course is
> regulated by an implicit index.

Have a look at INSERT ... RETURNING.  It can feed back the new rows to
your application so that you can make your 2nd insert without having to
pre/reselect them (assuming your running 8.2+)

klint.

--
Klint Gore
Database Manager
Sheep CRC
A.G.B.U.
University of New England
Armidale NSW 2350

Ph: 02 6773 3789
Fax: 02 6773 3266
EMail: kgore4@une.edu.au