Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-docspgsql-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

pgsql-docs by date

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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group