From: Roland Roberts <roland@astrofoto.org>
To: pgsql-sql@postgresql.org
Subject: Re: INSERT question
Date: 15 Nov 2001 15:03:00 -0500
Message-ID: <m21yizhkej.fsf@tycho.rlent.pnet> (raw)
In-Reply-To: <878zd7vpzn.fsf@npa01zz001.simplot.com>
References: <1f5f2b44.0111130130.17e8e57a@posting.google.com>
<3bf19679$0$189$e4fe514c@newszilla.xs4all.nl>
<878zd7vpzn.fsf@npa01zz001.simplot.com>
>>>>> "Jason" == Jason Earl <jason.earl@simplot.com> writes:
Jason> Even better, however, is to use the functions nextval() and
Jason> currval() like so:
Jason> INSERT INTO parent_table (data) values ('some data');
Jason> INSERT INTO child_table (parent, more_data)
Jason> (currval('parent_table_p_key_seq'),
Jason> 'more data');
The above is probably the best for a pure-SQL way with the caveat
that it should be wrapped in a transaction or currval() may not be
what you expect; i.e., another client may add a row and you get a
value different from what you inserted.
roland
--
PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD RL Enterprises
roland@rlenter.com 76-15 113th Street, Apt 3B
roland@astrofoto.org Forest Hills, NY 11375
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: roland@astrofoto.org
Subject: Re: INSERT question
In-Reply-To: <m21yizhkej.fsf@tycho.rlent.pnet>
* 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