Thread: Sequence docs

Sequence docs

From
"August Zajonc"
Date:
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





Re: Sequence docs

From
Thomas Lockhart
Date:
> 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


Re: Sequence docs

From
Vince Vielhaber
Date:
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
atPop4 Networking       Online Campground Directory    http://www.camping-usa.com      Online Giftshop Superstore
http://www.cloudninegifts.com
==========================================================================





Re: Sequence docs

From
Tom Lane
Date:
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


Re: Sequence docs

From
Tom Lane
Date:
"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


Re: Sequence docs

From
bpalmer
Date:
> 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-4983b. palmer,  bpalmer@crimelabs.net           pgp:crimelabs.net/bpalmer.pgp5
 



Re: Sequence docs

From
Tom Lane
Date:
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


Re: Sequence docs

From
Barry Lind
Date:
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
> 
> 




Re: Sequence docs

From
Bruce Momjian
Date:
> 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,
Pennsylvania19026
 


Re: Sequence docs

From
Vince Vielhaber
Date:
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
atPop4 Networking       Online Campground Directory    http://www.camping-usa.com      Online Giftshop Superstore
http://www.cloudninegifts.com
==========================================================================





Re: Sequence docs

From
Tom Lane
Date:
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


Re: Sequence docs

From
Barry Lind
Date:
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
> 
> 




Re: Sequence docs

From
Vince Vielhaber
Date:
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
atPop4 Networking       Online Campground Directory    http://www.camping-usa.com      Online Giftshop Superstore
http://www.cloudninegifts.com
==========================================================================