| 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: | Whole Thread | Raw Message | 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
| 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() |
| 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 :(((( |