pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / 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>
  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-07-01 02:45  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Naomi Walker <nwalke@eldocomp.com>
  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