Re: [ADMIN] Sequence update function?

[Thomas Markus]

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


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings