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