by ahodgson@[EMAIL PROTECTED]
(Alan Hodgson)
Mar 28, 2008 at 09:35 AM
On Friday 28 March 2008, Ognjen Blagojevic <ognjen@[EMAIL PROTECTED]
> wrote:
> Here, I used literal value for ID (1000), and I want my sequence to be
> updated to 1000 automatically (i.e. without calling setval).
You could probably use a trigger to do it, but it's not a great idea.
What you should do is fetch the next value from the sequence yourself and
then use it in the insert. Or, if you're pre-loading existing data, load
it
and then set the sequence value afterwards.
--
Alan
--
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
