new serial type - Mailing list pgsql-sql

From Rolf Johansson
Subject new serial type
Date
Msg-id 7j3denn367.fsf@junk.nocrew.org
Whole thread Raw
Responses Re: new serial type  (Kaare Rasmussen <kar@webline.dk>)
List pgsql-sql
Is there some function to change the serial type to, instead of reading
a next-value, read the maxium value in a column and then add x? If, for
some reason, the sequence is not updated (when I'm doing COPY into a
table), I'll have to recreate the sequence. Instead, it would be much
more simple just to take the max()+x value for a new type of serial type.

/Rolf


pgsql-sql by date:

Previous
From: Najm Hashmi
Date:
Subject: pl/pgsql Limits
Next
From: Kaare Rasmussen
Date:
Subject: Re: new serial type