Re: alter sequence + subqueries

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: jeff sacksteder <jsacksteder(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: alter sequence + subqueries
Date: 2005-09-16 23:27:19
Message-ID: 20050916232719.GA96425@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Magnus Hagander 2005-09-17 13:55:18 Re: How to install Postgresql 8 on different drive letter?
Previous Message Kenneth Dombrowski 2005-09-16 23:27:10 Re: plpgsql function not accepting NULL value