Re: Bug in create type when missed the comma between element list

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Diego <mrstephenamell(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Bug in create type when missed the comma between element list
Date: 2024-11-04 16:19:38
Message-ID: CAKFQuwagJ42WQR_-r1YLN5BYiom8c9oFYac6nkeGfUUkpQMzSA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Nov 4, 2024 at 9:17 AM Diego <mrstephenamell(at)gmail(dot)com> wrote:

>
> u: daf db: daf # CREATE TYPE test_enum AS ENUM(
> 'one'
> 'two',
> 'three',
> 'four'
> );
>
> maybe, some of you can help me to report it properly.
>
That is working per SQL standard. If you hadn't used newlines between
the elements you would have gotten an error; but the newlines between
literals is valid string literal syntax.

https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-STRINGS

David J.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2024-11-04 16:22:17 Re: Wrong security context for deferred triggers?
Previous Message Diego 2024-11-04 16:17:14 Bug in create type when missed the comma between element list