Skip site navigation (1) Skip section navigation (2)

Re: Composed Key and autoincrement

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: fbn <fbn79(at)libero(dot)it>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Composed Key and autoincrement
Date: 2007-02-06 05:23:39
Message-ID: 29787.1170739419@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
fbn <fbn79(at)libero(dot)it> writes:
> I want to create a table with a primary key composed of 2 auto increment
> (serial) value.

I do not understand why you think that's a good idea.  If you're worried
that 2^32 values isn't enough, use a bigserial.

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Ashish KaralkarDate: 2007-02-06 07:11:42
Subject: Re: Stored Procedure to return a result set
Previous:From: Tom LaneDate: 2007-02-06 05:21:37
Subject: Re: is there more documentation?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group