Home > mailing lists

Re: alter sequence + subqueries - Mailing list pgsql-sql

From	Michael Fuhr
Subject	Re: alter sequence + subqueries
Date	September 16, 2005 23:30:30
Msg-id	20050916232719.GA96425@winnie.fuhr.org Whole thread Raw
In response to	alter sequence + subqueries (jeff sacksteder <jsacksteder@gmail.com>)
List	pgsql-sql

Tree view

On Fri, Sep 16, 2005 at 06:36:48PM -0400, jeff sacksteder wrote:
> ALTER SEQUENCE foo_id_seq 
> RESTART WITH (SELECT max(id) FROM foo);
> 
> Is this syntax correct and supported?

Not according to the documentation; for an alternative see the
example under "User Comments":

http://www.postgresql.org/docs/8.0/interactive/sql-altersequence.html

-- 
Michael Fuhr

pgsql-sql by date:

From: Kenneth Dombrowski
Date: 16 September 2005, 23:27:14
Subject: Re: plpgsql function not accepting NULL value

From: "Magnus Hagander"
Date: 17 September 2005, 13:57:14
Subject: Re: How to install Postgresql 8 on different drive letter?

Re: alter sequence + subqueries - Mailing list pgsql-sql

Previous

Next