| From: | Ray O'Donnell <ray(at)rodonnell(dot)ie> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, 'PostgreSQL' <pgsql-general(at)postgresql(dot)org>, Thomas Kellerer <spam_eater(at)gmx(dot)net> |
| Subject: | Re: Resetting identity columns |
| Date: | 2019-04-23 15:02:24 |
| Message-ID: | 82479acf-ee88-95c1-5e0b-9520e323c97c@rodonnell.ie |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 22/04/2019 18:49, Tom Lane wrote:
> "Ray O'Donnell" <ray(at)rodonnell(dot)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(at)rodonnell(dot)ie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Souvik Bhattacherjee | 2019-04-23 21:56:24 | Quick hack for fetching the contents of a temp table |
| Previous Message | Rich Shepard | 2019-04-23 14:17:29 | Re: Primary key data type: integer vs identity |