Re: [GENERAL] Problem with the sequence

2005-02-07 Thread sid tow
Thanks that should help but what about the rest of the columns can u explain what is "is_cycled" and "cache_value". Thanks in advance.Richard Huxton wrote: sid tow wrote:> HI> > I have a problem locating the documentation for "sequence". I want to get the detailed information about the columns

Re: [GENERAL] Problem with the sequence

2005-02-03 Thread Richard Huxton
sid tow wrote: Thanks that should help but what about the rest of the columns can u explain what is "is_cycled" and "cache_value". Thanks in advance. See the manuals. Section "SQL Commands", "CREATE SEQUENCE" -- Richard Huxton Archonet Ltd ---(end of broadcast)--

Re: [GENERAL] Problem with the sequence

2005-02-03 Thread sid tow
Thanks that should help but what about the rest of the columns can u explain what is "is_cycled" and "cache_value". Thanks in advance.Richard Huxton wrote: sid tow wrote:> HI> > I have a problem locating the documentation for "sequence". I want to get the detailed information about the columns pre

Re: [GENERAL] Problem with the sequence

2005-02-03 Thread Carlos Costa
I wrote a very basic entry about this at improveyourweb some weeks ago (http://www.improveyourweb.com/?q=node/2). Hope it helps. In the source code, sequence.c, you can read something like: /* * Decide whether we should emit a WAL log record. If so, force up * the fetc

Re: [GENERAL] Problem with the sequence

2005-02-03 Thread Richard Huxton
sid tow wrote: HI I have a problem locating the documentation for "sequence". I want to get the detailed information about the columns present in a sequence table ie when I do psql=# select * from foo_seq; sequence_name | last_value | increment_by | max_value | min_value

[GENERAL] Problem with the sequence

2005-02-02 Thread sid tow
HI   I have a problem locating the documentation for "sequence". I want to get the detailed information about the columns present in a sequence table ie when I do   psql=# select * from foo_seq;  sequence_name   | last_value | increment_by |  max_value  | min_value | cache_value