| From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
|---|---|
| To: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
| Cc: | pgsql-committers <pgsql-committers(at)postgresql(dot)org> |
| Subject: | Re: pgsql: Identity columns |
| Date: | 2017-04-07 21:39:10 |
| Message-ID: | 6ed8f35e-50be-367f-4e05-8aeea6c87bd5@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
On 4/6/17 23:13, David Rowley wrote:
> On 7 April 2017 at 00:44, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
>> Identity columns
>>
>> This is the SQL standard-conforming variant of PostgreSQL's serial
>> columns. It fixes a few usability issues that serial columns have:
>>
>> - CREATE TABLE / LIKE copies default but refers to same sequence
>> - cannot add/drop serialness with ALTER TABLE
>> - dropping default does not drop sequence
>> - need to grant separate privileges to sequence
>> - other slight weirdnesses because serial is some kind of special macro
>
> Attached is a small patch which fixes up a warning for compilers not
> smart enough to know the elog(ERROR) does not return.
fixed
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2017-04-07 21:50:58 | pgsql: Improve 64bit atomics support. |
| Previous Message | Peter Eisentraut | 2017-04-07 21:37:49 | pgsql: Fix compiler warning |