Re: insert without oids

From: Michael Stone
Subject: Re: insert without oids
Date: ,
Msg-id: 20060113224800.GJ1408@mathom.us
(view: Whole thread, Raw)
In response to: Re: insert without oids  (Neil Conway)
List: pgsql-performance

Tree view

insert without oids  (Michael Stone, )
 Re: insert without oids  (Michael Fuhr, )
 Re: insert without oids  (Neil Conway, )
  Re: insert without oids  (Michael Stone, )

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:

From: Bruce Momjian
Date:
Subject: Re: Extremely irregular query performance
From: vimal.gupta@gmail.com
Date:
Subject: Hanging Query