Postgres Pro
Downloads
Home   >   mailing lists

Re: Sequence docs - Mailing list pgsql-hackers

From bpalmer
Subject Re: Sequence docs
Date
Msg-id Pine.BSO.4.40.0111281214250.29297-100000@mizer.
Whole thread Raw
In response to Re: Sequence docs  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Sequence docs
List pgsql-hackers
Tree view 
> 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

pgsql-hackers by date:

Previous
From: Luis Amigo
Date:
Subject: Re: Call for platform testing
Next
From: Antonio Fiol Bonnín
Date:
Subject: Re: FW: [ppa-dev] Severe bug in debian - phppgadmin opens up