Re: Resetting identity columns - Mailing list pgsql-general

From Ray O'Donnell
Subject Re: Resetting identity columns
Date
Msg-id 82479acf-ee88-95c1-5e0b-9520e323c97c@rodonnell.ie
Whole thread Raw
In response to Re: Resetting identity columns  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On 22/04/2019 18:49, Tom Lane wrote:
> "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.

Fair enough. Thanks Tom, Adrian & Thomas for the help!

Ray.

-- 
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie



pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Primary key data type: integer vs identity
Next
From: Souvik Bhattacherjee
Date:
Subject: Quick hack for fetching the contents of a temp table