Sequence docs

Started by August Zajoncover 24 years ago13 messageshackers
Jump to latest
#1August Zajonc
junk-pgsql@aontic.com

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

#2Thomas Lockhart
lockhart@fourpalms.org
In reply to: August Zajonc (#1)
Re: 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

#3Vince Vielhaber
vev@michvhf.com
In reply to: Thomas Lockhart (#2)
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
==========================================================================

#4Tom Lane
tgl@sss.pgh.pa.us
In reply to: Thomas Lockhart (#2)
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

#5Tom Lane
tgl@sss.pgh.pa.us
In reply to: August Zajonc (#1)
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

#6bpalmer
bpalmer@crimelabs.net
In reply to: Tom Lane (#5)
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

#7Barry Lind
barry@xythos.com
In reply to: August Zajonc (#1)
Re: Sequence docs

I'll work on the JDBC ones.

thanks,
--Barry

Tom Lane wrote:

Show quoted text

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

#8Tom Lane
tgl@sss.pgh.pa.us
In reply to: bpalmer (#6)
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

#9Bruce Momjian
bruce@momjian.us
In reply to: Vince Vielhaber (#3)
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
#10Vince Vielhaber
vev@michvhf.com
In reply to: Bruce Momjian (#9)
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
==========================================================================

#11Barry Lind
barry@xythos.com
In reply to: August Zajonc (#1)
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:

Show quoted text

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

#12Tom Lane
tgl@sss.pgh.pa.us
In reply to: Barry Lind (#11)
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

#13Vince Vielhaber
vev@michvhf.com
In reply to: Barry Lind (#11)
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
==========================================================================