Re: Bug in create type when missed the comma between element list - Mailing list pgsql-hackers

Thank you David!

That note: This slightly bizarre behavior is specified by SQL; PostgreSQL is following the standard.

On Mon, Nov 4, 2024 at 9:17 AM Diego <mrstephenamell@gmail.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.