Re: insert without oids - Mailing list pgsql-performance

From Michael Stone
Subject Re: insert without oids
Date
Msg-id 20060113224800.GJ1408@mathom.us
Whole thread Raw
In response to Re: insert without oids  (Neil Conway)
List pgsql-performance
On Fri, Jan 13, 2006 at 04:29:15PM -0500, Neil Conway wrote:
>There's really no additional operations required:
>INSERT INTO t2 VALUES (currval('t1_id_seq'), ...);
>You need a separate SELECT if you want to use the generated sequence
>value outside the database,

That would, of course, be the goal. IOW, if you have a table which has
data which is unique only for the serial column, the old syntax provided
a way to refer to the newly inserted row uniquely without any additional
operations.

>although the INSERT ... RETURNING extension will avoid that

That sounds promising. I'll have to put the TODO list on my todo list.
:)

Mike Stone

pgsql-performance by date:

Previous
From: Neil Conway
Date:
Subject: Re: insert without oids
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Slow query with joins