well, almost everything is in the subject !
I have to fill 2 tables (more complicated than in the example !):
CREATE TABLE A (
id serial primary key,
CREATE TABLE B (
id serial references A,
I fill A with :
INSERT into A VALUES (DEFAULT, "toto");
Then I need to retreive the "A.id" that was given to A, in order to give it
to B.id. If I was doing this by hand, it would have been quite easy, but I'm
doing this with a script.
So, if I make a SELECT id from A; and take the last row, will it *always*
be the row that I've just inserted.
Thanks for any tip
pgsql-general by date
|Next:||From: Matthew T. O'Connor||Date: 2004-05-19 13:43:23|
|Subject: Re: Is using cross-version pg_autovacuum possible/safe?|
|Previous:||From: Marco Lazzeri||Date: 2004-05-19 12:50:11|
|Subject: Re: Restricted query|