Re: Sequence update function?
От
Thomas Markus
Тема
Re: Sequence update function?
Дата
Msg-id
466E3DAC.10209@proventis.net
Ответ на
Sequence update function? (Uwe C. Schroeder)
Список
Дерево обсуждения
Sequence update function? "Uwe C. Schroeder" <uwe@oss4u.com>
Re: Sequence update function? Thomas Markus <t.markus@proventis.net>
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?
>
В списке pgsql-admin по дате отправления
