From: Wilco Boschman <w.boschman@xs4all.nl>
To: pgsql-sql@postgresql.org
Subject: Re: INSERT question
Date: Tue, 13 Nov 2001 22:51:53 +0100
Message-ID: <3bf19679$0$189$e4fe514c@newszilla.xs4all.nl> (raw)
References: <1f5f2b44.0111130130.17e8e57a@posting.google.com>
Insert the row into the parent table (the one with the primary key), then do
a
select max(<serial-column>) from parent_table;
This will give you the greatest number in the table, that is if everything
went ok the number from the row you just inserted. Then insert the row(s)
into the second table and use the value you got from the parent table in the
foreign key
cheers
Wilco
"Brian" <Brian@McSweeney.iol.ie> schreef in bericht
news:1f5f2b44.0111130130.17e8e57a@posting.google.com...
| Hi everyone,
| I've a little question about using insert statements. I've got a
| parent table with a "serial" (automatically incrementing integer)
| primary key. I have a child table with a foreign key which references
| that primary key. My question is:
|
| To insert values into the child table corresponding to an entry in the
| parent table, how do I get a reference to the serial primary key (so
| as I can reference it for the foreign key entry)
|
| Hope you understand what I mean. This should be a regular occurance
| and seeing as I'm not an sql guru, I just don't have a clue!
|
| Any help would be SOOO appreciated.
| Brian
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: w.boschman@xs4all.nl
Subject: Re: INSERT question
In-Reply-To: <3bf19679$0$189$e4fe514c@newszilla.xs4all.nl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox