pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Sequence Number question 2+ messages / 2 participants [nested] [flat]
* Sequence Number question @ 2004-06-25 18:27 Naomi Walker <nwalke@eldocomp.com> 2004-07-01 02:45 ` Re: Sequence Number question Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: Naomi Walker @ 2004-06-25 18:27 UTC (permalink / raw) To: pgsql-admin We are using Postgres 7.3.2 on a Solaris box. When I dump a schema with a SEQUENCE in it, it shows the MAXVAL as 2,147,483,647. Is it possible to set this number higher? When we get to maxval, does it wrap? -- ------------------------------------------------------------------------- Naomi Walker Chief Information Officer Eldorado Computing, Inc. nwalker@eldocomp.com 602-604-3100 ------------------------------------------------------------------------- Thought is the blossom; language the bud; action the fruit behind it. - Ralph Waldo Emerson ------------------------------------------------------------------------- -- CONFIDENTIALITY NOTICE -- This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use, copy, disclose or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email, and delete the message. Thank you. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Sequence Number question 2004-06-25 18:27 Sequence Number question Naomi Walker <nwalke@eldocomp.com> @ 2004-07-01 02:45 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2004-07-01 02:45 UTC (permalink / raw) To: nwalker@eldocomp.com <nwalker@eldocomp.com>; +Cc: pgsql-admin Naomi Walker <nwalke@eldocomp.com> writes: > We are using Postgres 7.3.2 on a Solaris box. > When I dump a schema with a SEQUENCE in it, it shows the MAXVAL as > 2,147,483,647. > Is it possible to set this number higher? Hmm ... 7.3 does have support for 64-bit sequences, if it was compiled on a compiler that has a 64-bit integer type. If you just do create sequence s; select * from s; what do you see for max_value? If it's 2147483647, then you need to get a better compiler and rebuild Postgres. If it's 9223372036854775807 then you're good, and what you probably have is a sequence that was dumped and reloaded from an older version of Postgres that didn't have 64-bit sequence support. I don't think 7.3 has ALTER SEQUENCE, but you could drop and recreate the sequence and then manually fix its current value. > When we get to maxval, does it wrap? Not unless you said CYCLE. Read the CREATE SEQUENCE man page. regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-07-01 02:45 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2004-06-25 18:27 Sequence Number question Naomi Walker <nwalke@eldocomp.com> 2004-07-01 02:45 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox