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.markus@xxxxxxxxxxxxx
tel;work:+49 30 29 36 399 22
x-mozilla-html:FALSE
url:http://www.proventis.net
version:2.1
end:vcard
