Re: getting back autonumber just inserted

From: PFC <lists(at)boutiquenumerique(dot)com>
To: "Michael Fuhr" <mike(at)fuhr(dot)org>, lmeadors(at)apache(dot)org
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: getting back autonumber just inserted
Date: 2005-07-07 22:26:30
Message-ID: op.stkdygr8th1vuj@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


> That's a different issue than whether currval() is subject to
> interference from other transactions. And just wait until PostgreSQL
> 8.1 comes out and people start using lastval() -- then it could get
> *really* confusing which sequence value you're getting.

What happens if an INSERT trigger inserts something into another table
which also has a sequence ?

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Alvaro Herrera 2005-07-07 22:42:27 Re: getting back autonumber just inserted
Previous Message Riya Verghese 2005-07-07 21:01:39 ORDER records based on parameters in IN clause