Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem with serial counters - Mailing list pgsql-sql

From Vibhor Kumar
Subject Re: Problem with serial counters
Date
Msg-id E58C1ADD-3B7D-470B-8061-A147387D89B9@gmail.com
Whole thread Raw
In response to Problem with serial counters  ("Jacques Lebrun" <jlebrun@cplus.org>)
List pgsql-sql
Tree view 
On Feb 25, 2011, at 2:39 AM, Jacques Lebrun wrote:
> What can I do to force PostGres to update the internat serial counter when I do an insert with a specified value for
theserial? 
>

After inserting the all the Data, use ALTER SEQUENCE Command:
http://www.postgresql.org/docs/8.4/static/sql-altersequence.html

Thanks & Regards,
Vibhor

pgsql-sql by date:

Previous
From: Yeb Havinga
Date:
Subject: Re: what's wrong in this procedure?
Next
From: Rob Sargent
Date:
Subject: Re: what's wrong in this procedure?