Re: Returning generated id after a transaction.

Hi,
which postgres version You are using?
do You perform this in function or as anonymous block, or at hoc query?

regards,
Bartek

2012/4/18 Guillaume Henriot <henriotg(at)gmail(dot)com>

> Hi,
>
> First of all excuse me if i'm not precise enough, english is not my native
> language.
>
> 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:
>
> BEGIN;
> INSERT INTO table1 (id, name) VALUES (DEFAULT, 'name_of_the_entry');
> UPDATE table2 SET table1_id = CURRVAL('table1_id_seq') WHERE id =
> 'some_row_id';
> SELECT CURRVAL('parts_id_seq') AS table1_id;
> COMMIT;
>
> 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
>