dbTalk Databases Forums  

Re: [BUGS] sequence last_value not accurate if sequence has never been used

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss Re: [BUGS] sequence last_value not accurate if sequence has never been used in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tom Lane
 
Posts: n/a

Default Re: [BUGS] sequence last_value not accurate if sequence has never been used - 08-31-2003 , 07:29 PM






Wayne Schroeder <raz (AT) chewies (DOT) net> writes:
Quote:
IMHO, it would be good for the last_value to come back null if is_called
is false. Don't know if that's possible or even a good idea --
It's not really very practical; among other things you'd lose the
ability to specify a START value different from MIN. Of course, if we
wanted to break backwards compatibility wholesale, we could doubtless
add a separate column for START, do away with is_called altogether in
favor of representing not-iscalled by last_value = null, etc. But I
doubt it's worth the pain of breaking clients that know the existing
definitions of these fields.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.