John Harrold wrote:
-- Start of PGP signed section.
> i've run into the situation where i need to set the last_value of a
> sequence. can someone tell me how this is done?
setval()?
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 3
Perhaps:
SELECT SETVAL('resrc_serial', MAX(resource_id)) FROM ia_resources;
the sequencethe column the table
This sets the sequence to the highest number after I have used "copy" to load a table;
other values instead of MAX() could be used (e.g. 123456, etc.).
HTH
