Any chance the sequence docs could be updated to indicate sequence bounds
(int4)?
http://www.postgresql.org/idocs/index.php?sql-createsequence.html

Perhaps note that int8 is coming?

How do user notes make it into the documentation proper.

-AZ




Tue, 27 Nov 2001 17:47:40 -0800
"August Zajonc" <junk-pgsql@aontic.com>
Sequence docs
> How do user notes make it into the documentation proper.

At the moment they don't. Afaik no one is taking those notes and folding
them into the docs where appropriate. It would be great if someone (or
several people) want to do that, and it would be a nice project for
anyone wanting to start contributing to PostgreSQL.

                       - Thomas

Wed, 28 Nov 2001 15:03:07 +0000
Thomas Lockhart <lockhart@fourpalms.org>
Re: Sequence docs
On Wed, 28 Nov 2001, Thomas Lockhart wrote:

> > How do user notes make it into the documentation proper.
>
> At the moment they don't. Afaik no one is taking those notes and folding
> them into the docs where appropriate. It would be great if someone (or
> several people) want to do that, and it would be a nice project for
> anyone wanting to start contributing to PostgreSQL.

I was under the impression Bruce had already started (if not finished)
that.  After 7.2 is released and the final docs are imported the current
docnotes are going to be cleared and therefore no longer available.

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
         56K Nationwide Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================




Wed, 28 Nov 2001 10:10:40 -0500 (EST)
Vince Vielhaber <vev@michvhf.com>
Re: Sequence docs
Thomas Lockhart <lockhart@fourpalms.org> writes:
>> How do user notes make it into the documentation proper.

> At the moment they don't. Afaik no one is taking those notes and folding
> them into the docs where appropriate.

I made a pass a week or two ago to incorporate notes where appropriate.
I did not go through the JDBC or ODBC sections, however, not feeling
competent to work on the documentation for those.

> It would be great if someone (or
> several people) want to do that, and it would be a nice project for
> anyone wanting to start contributing to PostgreSQL.

It'd be real nice if someone could look through the JDBC and/or ODBC notes
and submit documentation patches before 7.2 goes final.

			regards, tom lane

Wed, 28 Nov 2001 11:04:37 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Sequence docs 
"August Zajonc" <junk-pgsql@aontic.com> writes:
> Any chance the sequence docs could be updated to indicate sequence bounds
> (int4)?

Done for 7.2, see
http://candle.pha.pa.us/main/writings/pgsql/sgml/sql-createsequence.html
http://candle.pha.pa.us/main/writings/pgsql/sgml/functions-sequence.html

			regards, tom lane

Wed, 28 Nov 2001 11:31:15 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Sequence docs 
> http://candle.pha.pa.us/main/writings/pgsql/sgml/sql-createsequence.html
> http://candle.pha.pa.us/main/writings/pgsql/sgml/functions-sequence.html

These lead me to a interesting question.  Though it would take a while,
what happens if you get the the max sequence number? It can't roll over...
are you just SOL?  (Just for some numbers,  to get to 2b,  it would be
~1000/sec for only 25 days)

- Brandon

----------------------------------------------------------------------------
 c: 646-456-5455                                            h: 201-798-4983
 b. palmer,  bpalmer@crimelabs.net           pgp:crimelabs.net/bpalmer.pgp5


Wed, 28 Nov 2001 12:21:21 -0500 (EST)
bpalmer <bpalmer@crimelabs.net>
Re: Sequence docs 
I'll work on the JDBC ones.

thanks,
--Barry

Tom Lane wrote:

> Thomas Lockhart <lockhart@fourpalms.org> writes:
> 
>>>How do user notes make it into the documentation proper.
>>>
> 
>>At the moment they don't. Afaik no one is taking those notes and folding
>>them into the docs where appropriate.
>>
> 
> I made a pass a week or two ago to incorporate notes where appropriate.
> I did not go through the JDBC or ODBC sections, however, not feeling
> competent to work on the documentation for those.
> 
> 
>>It would be great if someone (or
>>several people) want to do that, and it would be a nice project for
>>anyone wanting to start contributing to PostgreSQL.
>>
> 
> It'd be real nice if someone could look through the JDBC and/or ODBC notes
> and submit documentation patches before 7.2 goes final.
> 
> 			regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> 
> 



Wed, 28 Nov 2001 09:30:03 -0800
Barry Lind <barry@xythos.com>
Re: Sequence docs
bpalmer <bpalmer@crimelabs.net> writes:
> These lead me to a interesting question.  Though it would take a while,
> what happens if you get the the max sequence number?

If you didn't say CYCLE, nextval() starts giving errors.

			regards, tom lane

Wed, 28 Nov 2001 13:00:20 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Sequence docs 
> On Wed, 28 Nov 2001, Thomas Lockhart wrote:
> 
> > > How do user notes make it into the documentation proper.
> >
> > At the moment they don't. Afaik no one is taking those notes and folding
> > them into the docs where appropriate. It would be great if someone (or
> > several people) want to do that, and it would be a nice project for
> > anyone wanting to start contributing to PostgreSQL.
> 
> I was under the impression Bruce had already started (if not finished)
> that.  After 7.2 is released and the final docs are imported the current
> docnotes are going to be cleared and therefore no longer available.

I don't know anything about those notes.  Sorry.  I am adding stuff from
email comments.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Wed, 28 Nov 2001 13:36:24 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Sequence docs
On Wed, 28 Nov 2001, Bruce Momjian wrote:

> > On Wed, 28 Nov 2001, Thomas Lockhart wrote:
> >
> > > > How do user notes make it into the documentation proper.
> > >
> > > At the moment they don't. Afaik no one is taking those notes and folding
> > > them into the docs where appropriate. It would be great if someone (or
> > > several people) want to do that, and it would be a nice project for
> > > anyone wanting to start contributing to PostgreSQL.
> >
> > I was under the impression Bruce had already started (if not finished)
> > that.  After 7.2 is released and the final docs are imported the current
> > docnotes are going to be cleared and therefore no longer available.
>
> I don't know anything about those notes.  Sorry.  I am adding stuff from
> email comments.

I thought it was you, but Tom Lane just mentioned having gone thru it.


Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
         56K Nationwide Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================




Wed, 28 Nov 2001 14:46:02 -0500 (EST)
Vince Vielhaber <vev@michvhf.com>
Re: Sequence docs
Docs have been updated to address the JDBC related notes.  Actually most 
were already addressed by previous doc cleanups.

thanks,
--Barry

Tom Lane wrote:

> Thomas Lockhart <lockhart@fourpalms.org> writes:
> 
>>>How do user notes make it into the documentation proper.
>>>
> 
>>At the moment they don't. Afaik no one is taking those notes and folding
>>them into the docs where appropriate.
>>
> 
> I made a pass a week or two ago to incorporate notes where appropriate.
> I did not go through the JDBC or ODBC sections, however, not feeling
> competent to work on the documentation for those.
> 
> 
>>It would be great if someone (or
>>several people) want to do that, and it would be a nice project for
>>anyone wanting to start contributing to PostgreSQL.
>>
> 
> It'd be real nice if someone could look through the JDBC and/or ODBC notes
> and submit documentation patches before 7.2 goes final.
> 
> 			regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> 
> 



Wed, 28 Nov 2001 21:36:40 -0800
Barry Lind <barry@xythos.com>
Re: Sequence docs
Barry Lind <barry@xythos.com> writes:
> Docs have been updated to address the JDBC related notes.  Actually most 
> were already addressed by previous doc cleanups.

Excellent.  Thanks!

			regards, tom lane

Thu, 29 Nov 2001 00:40:25 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Sequence docs 
On Wed, 28 Nov 2001, Barry Lind wrote:

> Docs have been updated to address the JDBC related notes.  Actually most
> were already addressed by previous doc cleanups.

Has anyone looked at the ODBC docs and docnotes?



>
> thanks,
> --Barry
>
> Tom Lane wrote:
>
> > Thomas Lockhart <lockhart@fourpalms.org> writes:
> >
> >>>How do user notes make it into the documentation proper.
> >>>
> >
> >>At the moment they don't. Afaik no one is taking those notes and folding
> >>them into the docs where appropriate.
> >>
> >
> > I made a pass a week or two ago to incorporate notes where appropriate.
> > I did not go through the JDBC or ODBC sections, however, not feeling
> > competent to work on the documentation for those.
> >
> >
> >>It would be great if someone (or
> >>several people) want to do that, and it would be a nice project for
> >>anyone wanting to start contributing to PostgreSQL.
> >>
> >
> > It'd be real nice if someone could look through the JDBC and/or ODBC notes
> > and submit documentation patches before 7.2 goes final.
> >
> > 			regards, tom lane
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> >
> >
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>


Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
         56K Nationwide Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================




Thu, 29 Nov 2001 06:13:51 -0500 (EST)
Vince Vielhaber <vev@michvhf.com>
Re: Sequence docs