Re: Resetting identity columns - Mailing list pgsql-general

From Tom Lane
Subject Re: Resetting identity columns
Date
Msg-id 19592.1555955370@sss.pgh.pa.us
Whole thread Raw
In response to Re: Resetting identity columns  (Ray O'Donnell <ray@rodonnell.ie>)
Responses Re: Resetting identity columns
List pgsql-general
"Ray O'Donnell" <ray@rodonnell.ie> writes:
> In general, then, is it not possible to use an expression thus? -

>      [...] ALTER COLUMN [...] RESTART WITH <expression here>

No.  In general, PG's utility commands (everything except SELECT/
INSERT/UPDATE/DELETE) don't do expression evaluation.  Partly this
is laziness or lack of round tuits, but in some cases there are
also interesting semantic problems.

            regards, tom lane



pgsql-general by date:

Previous
From: Ray O'Donnell
Date:
Subject: Re: Resetting identity columns
Next
From: Adrian Klaver
Date:
Subject: Re: Resetting identity columns