Re: lastval(seq) ?

--- "scott.marlowe" <scott.marlowe@ihs.com> wrote:
> On Mon, 20 Oct 2003, CSN wrote:
>
> > How do you get the last value of a sequence
> without
> > having called nextval? phppgadmin displays last
> value
> > for sequences (I haven't found out how yet rooting
> > through the code).
>
> First, the mandatory, why would you want to do that?

For updating sequences after copy importing data (with
id's).

select setval('table_id_seq', (select max(id) from
table));

vs.

select setval('table_id_seq', (select last_value from
table_id_seq));

Is there a transaction-safe way?

CSN


>
>
> Second: select last_value from table_id_seq;
>
> It's not transaction safe, so don't expect it to
> work right on busy
> multi-user systems.
>


__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com