Re: Using autogenerated primary key in transaction - Mailing list pgsql-general

From A. Kretschmer
Subject Re: Using autogenerated primary key in transaction
Date
Msg-id 20100104082918.GC6379@a-kretschmer.de
Whole thread Raw
In response to Using autogenerated primary key in transaction  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-general
In response to Andrus :
> INSERT generates SERIAL primary key column value automatically.
>
> How to save this value for use in same transaction ?
> How to get autogenerated primary key for >=8.0 servers ?

There are some functions to get that value:


test=# create table andrus(id serial primary key);
NOTICE:  CREATE TABLE will create implicit sequence "andrus_id_seq" for serial column "andrus.id"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "andrus_pkey" for table "andrus"
CREATE TABLE
test=*# insert into andrus values (default);
INSERT 0 1
test=*# select currval(pg_get_serial_sequence('andrus','id'));
 currval
---------
       1
(1 row)


HTH, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431  2EB0 389D 1DC2 3172 0C99

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: SELECT does not find table created by itself
Next
From: Magnus Hagander
Date:
Subject: Re: stats collector process: WRDSK = WRDSK_CANCEL?