undocumented setval()

Started by Cedar Coxover 24 years ago2 messagesdocs
Jump to latest
#1Cedar Cox
cedarc@visionforisrael.com

When looking through a dump file, I noticed a setval(text, int,
bool). What is this? It doesn't appear to be documented.

-Cedar

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Cedar Cox (#1)
Re: [SQL] undocumented setval()

Cedar Cox <cedarc@visionforisrael.com> writes:

When looking through a dump file, I noticed a setval(text, int,
bool). What is this? It doesn't appear to be documented.

The bool parameter sets the is_called state bit of the sequence.
Without this you can't restore a sequence to a virgin "never nextval'd"
state.

Actually, none of the sequence-related functions are documented in
what I'd call a proper way. I think there should be a separate section
of the user's guide "Functions and Operators" chapter that describes
them --- not a large section, but a section nonetheless. Any
volunteers to write it?

regards, tom lane