Re: [SQL] undocumented setval() - Mailing list pgsql-docs

From Tom Lane
Subject Re: [SQL] undocumented setval()
Date
Msg-id 18557.998839474@sss.pgh.pa.us
Whole thread Raw
List pgsql-docs
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

pgsql-docs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Man page section for SQL commands
Next
From: Peter Eisentraut
Date:
Subject: Commit docbook2man?