Re: Sequence update function?

[Thomas Markus <t(dot)markus(at)proventis(dot)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?
>   

begin:vcard
fn:Thomas Markus
n:Markus;Thomas
org:proventis GmbH
adr:;;Zimmerstr. 79-80;Berlin;Berlin;10117;Germany
email;internet:t(dot)markus(at)proventis(dot)net
tel;work:+49 30 29 36 399 22
x-mozilla-html:FALSE
url:http://www.proventis.net
version:2.1
end:vcard