Re: Problem with serial counters

From: Vibhor Kumar <vibhor(dot)aim(at)gmail(dot)com>
To: Jacques Lebrun <jlebrun(at)cplus(dot)org>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Problem with serial counters
Date: 2011-02-25 18:47:24
Message-ID: E58C1ADD-3B7D-470B-8061-A147387D89B9@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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 the serial?
>

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

Thanks & Regards,
Vibhor

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Rob Sargent 2011-02-25 21:39:44 Re: what's wrong in this procedure?
Previous Message Yeb Havinga 2011-02-25 18:38:52 Re: what's wrong in this procedure?