Re: [GENERAL] [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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general