Restart PostgreSQL sequence – how to?

I thought this would work:

ALTER SEQUENCE users_id_seq RESTART WITH (SELECT MAX(id) FROM users);

but it doesn’t! :O It throws “ERROR: syntax error at or near “select” “!

If you have this problem, try the other approach:

SELECT SETVAL(‘users_id_seq’,(SELECT MAX(id) FROM users));

Tested on version 8.4.0, on FreeBSD 8.0…

Be the first to like this post.

This entry was posted on September 16, 2010 at 0909 and is filed under Computing, Linux & Open Source. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Not published)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Connecting to %s

Mario’s Weblog