AW: [HACKERS] Sequence objects have no global currval operator? - Mailing list pgsql-hackers

From Andreas Zeugswetter
Subject AW: [HACKERS] Sequence objects have no global currval operator?
Date
Msg-id 01BDAF11.3AB30EC0@zeugswettera.user.lan.at
Whole thread Raw
Responses Re: AW: [HACKERS] Sequence objects have no global currval operator?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
>Bruce Momjian <maillist@candle.pha.pa.us> writes:
>> How about SELECT * FROM sequence_table_name?
>
>Ah, of course.  The man page for CREATE SEQUENCE only mentions getting
>the sequence parameters that way, but you can get the last_value as
>well, which is exactly what I need.

What do you think of making currval return exactly this, only in the
case where nextval was not yet called by this client ?

I don't think anybody does rely on currval returning null iff nextval was not yet called
in his current session.

Andreas



pgsql-hackers by date:

Previous
From: "Thomas G. Lockhart"
Date:
Subject: Re: Recent updates
Next
From: Vadim Mikheev
Date:
Subject: Q about read committed in Oracle...