pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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





view thread (12+ messages)  latest in thread

Message-ID: <3bf19679$0$189$e4fe514c@newszilla.xs4all.nl>
Permalink:  ../3bf19679$0$189$e4fe514c@newszilla.xs4all.nl/
Also on:    postgresql.org/message-id/3bf19679$0$189$e4fe514c@newszilla.xs4all.nl

 · 

reply

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