Re: pgsql: Prohibit identity columns on typed tables and partitions

Peter Eisentraut <peter.eisentraut@2ndquadrant.com>

From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>

To: Magnus Hagander <magnus@hagander.net>, Michael Paquier <michael.paquier@gmail.com>

Cc: PostgreSQL mailing lists <pgsql-hackers@postgresql.org>

Date: 2017-12-09T13:45:36Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Prohibit identity columns on typed tables and partitions
- 005ac298b1bd 11.0 cited

On 12/9/17 05:47, Magnus Hagander wrote:
> 
> 
> On Sat, Dec 9, 2017 at 8:43 AM, Michael Paquier
> <michael.paquier@gmail.com <mailto:michael.paquier@gmail.com>> wrote:
> 
>     On Sat, Dec 9, 2017 at 2:26 AM, Peter Eisentraut <peter_e@gmx.net
>     <mailto:peter_e@gmx.net>> wrote:
>     > Prohibit identity columns on typed tables and partitions
>     >
>     > Those cases currently crash and supporting them is more work then
>     > originally thought, so we'll just prohibit these scenarios for now.
> 
>     +                               (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
>     +                                errmsg("identify columns are not
>     supported on partitions")));
>     Er... s/identify/identity/. My fault I guess.
> 
> 
> Spotted the separate report on it first, so a fix has been pushed.

Please also backpatch to PG10.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services