Re: Automatically update sequence

[Alan Hodgson <ahodgson(at)simkin(dot)ca>]

On Friday 28 March 2008, Ognjen Blagojevic <ognjen(at)etf(dot)bg(dot)ac(dot)yu> 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