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

2024-11-04 Thread David G. Johnston
On Mon, Nov 4, 2024 at 9:17 AM Diego 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

Re: Wrong security context for deferred triggers?

2024-11-04 Thread Tom Lane
Pavel Stehule writes: > I'll mark this patch as ready for committer The cfbot points out a minor problem [1]: create role groot; +WARNING: roles created by regression test cases should have names starting with "regress_" create role outis; +WARNING: roles created by regression test cases sh

Re: pg_dump --no-comments confusion

2024-11-04 Thread Erik Wienhold
On 2024-11-04 16:13 +0100, Matthias van de Meent wrote: > On Mon, 4 Nov 2024 at 15:41, Bruce Momjian wrote: > > > > Someone emailed me privately saying they were confused because they > > thought pg_dump --no-comments would remove SQL comments, not the SQL > > COMMENT commands. Is this something

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

2024-11-04 Thread Diego
Thank you David! That note: This slightly bizarre behavior is specified by SQL; PostgreSQL is following the standard. On 11/4/24 13:19, David G. Johnston wrote: On Mon, Nov 4, 2024 at 9:17 AM Diego wrote: u: daf db: daf # CREATE TYPE test_enum AS ENUM(     'one'     'two',

<    1   2