Re: [SQL] undocumented setval()

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Cedar Cox <cedarc(at)visionforisrael(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org, pgsql-docs(at)postgresql(dot)org
Subject: Re: [SQL] undocumented setval()
Date: 2001-08-26 15:24:34
Message-ID: 18557.998839474@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-sql

Cedar Cox <cedarc(at)visionforisrael(dot)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

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Lee Chua 2001-08-27 03:09:40 Pg.pm documentation
Previous Message Cedar Cox 2001-08-26 08:40:33 undocumented setval()

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-08-26 15:44:54 Re: Different Choices For Index/Sequential Scan With And Without A Join In 7.2
Previous Message Meszaros Attila 2001-08-26 12:38:10 "AND", "OR" and Materialize :((((