| From: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | pgsql-committers <pgsql-committers(at)postgresql(dot)org> |
| Subject: | Re: pgsql: Identity columns |
| Date: | 2017-04-07 03:13:29 |
| Message-ID: | CAKJS1f8UW=ZN8uZ9L2P-rkN3404n6tnXTDUiX0Yq5VbEbzQabA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
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.
--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| Attachment | Content-Type | Size |
|---|---|---|
| identity_columns_warning_fix.patch | application/octet-stream | 690 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2017-04-07 03:28:56 | pgsql: Remove extraneous comma to satisfy picky compiler |
| Previous Message | Andrew Dunstan | 2017-04-07 02:22:36 | pgsql: Make json_populate_record and friends operate recursively |