which postgres version You are using?
do You perform this in function or as anonymous block, or at hoc query?
2012/4/18 Guillaume Henriot <henriotg(at)gmail(dot)com>
> First of all excuse me if i'm not precise enough, english is not my native
> I have a small problem while using transactions. I'm doing an INSERT in
> one table, an UPDATE in another table and then i'm trying to retrieve the
> id generated by the serial in the first table but the few things I have
> tryed does not return anything. Here is a sample of my transaction:
> INSERT INTO table1 (id, name) VALUES (DEFAULT, 'name_of_the_entry');
> UPDATE table2 SET table1_id = CURRVAL('table1_id_seq') WHERE id =
> SELECT CURRVAL('parts_id_seq') AS table1_id;
> I have tryed with RETURNING id on the INSERT too and pgadmin tells me each
> time this kind of message : "query result of 1 line cancelled".
> It works well when I do it without the begin and commit, so as a pgsql
> beginner I'm a bit lost.
> Guillaume Henriot
In response to
pgsql-novice by date
|Next:||From: ennio||Date: 2012-04-18 22:16:54|
|Subject: Re: Escaping literal strings in pg_8.4|
|Previous:||From: Guillaume Henriot||Date: 2012-04-18 18:12:34|
|Subject: Returning generated id after a transaction.|