Re: Last_Inserted Value - Mailing list pgsql-admin

From Andre Schubert
Subject Re: Last_Inserted Value
Date
Msg-id 3CA938F7.F8EB74E5@km3.de
Whole thread Raw
In response to Last_Inserted Value  (Andre Schubert <andre.schubert@km3.de>)
List pgsql-admin
Tom Lane schrieb:
>
> Andre Schubert <andre.schubert@km3.de> writes:
> > All three tables use the same sequence to increment their id.
> > I want to know if it is possible to find the id of the inserted value of
> > foo.
>
> Try "currval".

I think i cant use it. because all three tables use the same sequence,
and currval
gives me the id from the insert of the last table, not of the first one.

pgsql-admin by date:

Previous
From: "William Meloney"
Date:
Subject: Re: Vacuum returns error
Next
From: Andre Schubert
Date:
Subject: Re: Log rotation