Re: BUG #14866: The generated constraint in the typed table causes the server to crash

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: gomer94(at)yandex(dot)ru
Cc: PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14866: The generated constraint in the typed table causes the server to crash
Date: 2017-10-23 14:09:22
Message-ID: CAB7nPqTtWi3S7ew6aCQqkHiUos5n=jigS=GMpV2vEbQCfU1qqA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Oct 23, 2017 at 4:44 PM, <gomer94(at)yandex(dot)ru> wrote:
> This sql code crashes the server:
>
> CREATE TYPE comp AS (f1 integer, f2 text, f3 bigint);
>
> CREATE TABLE typed_table OF comp (
> f1 WITH OPTIONS GENERATED ALWAYS AS IDENTITY);

Thanks for the report. I can reproduce the crasher here. The problem
happens when doing a type name lookup when transforming the CREATE
clause in the parser. Looking into it now.
--
Michael

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Reinier Haasjes 2017-10-23 14:12:46 Re: [pg_dump] not dumping some default privileges
Previous Message Alvaro Herrera 2017-10-23 14:03:57 Re: [pg_dump] not dumping some default privileges