Re: Resetting identity columns

Поиск
Список
Период
Сортировка
От Ray O'Donnell
Тема Re: Resetting identity columns
Дата
Msg-id 82479acf-ee88-95c1-5e0b-9520e323c97c@rodonnell.ie
обсуждение исходный текст
Ответ на Re: Resetting identity columns  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Rich Shepard
Дата:
Сообщение: Re: Primary key data type: integer vs identity
Следующее
От: Souvik Bhattacherjee
Дата:
Сообщение: Quick hack for fetching the contents of a temp table