Postgres Pro
Downloads
Home   >   mailing lists

Last insert id - Mailing list pgsql-sql

From mixo
Subject Last insert id
Date
Msg-id 40C6AD19.70302@coza.net.za
Whole thread Raw
Responses Re: Last insert id  (Richard Huxton <dev@archonet.com>)
Re: Last insert id  ("Andrei Bintintan" <klodoma@ar-sd.net>)
List pgsql-sql
Tree view 
I have three tables which are related a serial field, table1_id, in on 
of the tables. Updating the tables is done through a transaction. My 
problem is, once I have insert  a row in the first tables with 
table1_id, I need for the other two tables. How can I get this? Is it 
safe to use "select max(table1_id) from table1" after the insert?

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Getting FK relationships from information_schema
Next
From: Peter Eisentraut
Date:
Subject: Re: Getting FK relationships from information_schema