Re: Sequence update function? - Mailing list pgsql-admin

From Thomas Markus
Subject Re: Sequence update function?
Date
Msg-id 466E3DAC.10209@proventis.net
Whole thread Raw
In response to Sequence update function?  ("Uwe C. Schroeder" <uwe@oss4u.com>)
List pgsql-admin
do a

select setval('sequence',max(col)+1) from tablename

for each table

tm

Uwe C. Schroeder schrieb:
> Hi,
>
> just thought I ask before I start doing it myself: Has anyone ever written a
> stored procedure (or any other means) of syncing the sequence to the max #
> key in the corresponding tables?
>


Attachment

pgsql-admin by date:

Previous
From: John DeSoi
Date:
Subject: Re: problems installing postgresql 8.0 on Mac OS
Next
From: "Mensinger, Oliver"
Date:
Subject: Re: How to restore updated records