Has anyone got any code that will automatically carry out setvals for serial
fields after loading data. I'm trying to write a function that will
identify and go through all sequences within the current database and 'fix'
the sequences to be set as the correct next value.
I cannot find any way of consistently identifiying the table/field that the
sequence has been defined over by interrogating the system catalogues.
The function so far is:
create function sys_refresh_sequences () returns integer as '
FOR myseq IN SELECT * FROM pg_class WHERE relkind=''S'' ORDER BY
myfield := substring(myseq.relname, 1,
RAISE NOTICE ''REFRESHING SEQUENCE % ON %'', myseq.relname,
' language 'plpgsql';
Any pointers would be appreciated
pgsql-admin by date
|Next:||From: Eric Day||Date: 2001-10-27 18:12:20|
|Subject: How can I..|
|Previous:||From: Emmanuel Guyot||Date: 2001-10-27 11:08:42|
|Subject: Re: pg_dump and timestamp : problem with TimeZone|