Re: DROP relation IF EXISTS Docs and Tests - Bug Fix - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: DROP relation IF EXISTS Docs and Tests - Bug Fix
Date
Msg-id CAFj8pRCc36pe5QYz1Ld9z-MANreONOAXhqQ7SoYL2h4XnYzitQ@mail.gmail.com
Whole thread Raw
In response to Re: DROP relation IF EXISTS Docs and Tests - Bug Fix  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: DROP relation IF EXISTS Docs and Tests - Bug Fix  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-hackers


út 14. 7. 2020 v 16:09 odesílatel David G. Johnston <david.g.johnston@gmail.com> napsal:
On Tue, Jul 14, 2020 at 6:56 AM Pavel Stehule <pavel.stehule@gmail.com> wrote:
út 14. 7. 2020 v 15:55 odesílatel David G. Johnston <david.g.johnston@gmail.com> napsal:
Further comments welcome so I'm putting it back into needs review for the moment while I work on the refactor.

attached fixed patch

all tests passed
doc build without problems

Thanks.

Actually, one question I didn't pose before, does the SQL standard define DROP TYPE to target domains while also providing for a DROP DOMAIN command?  Do drop commands for the other types we have not exist because those aren't SQL standard types (or the standard they are standard types but the commands aren't defined)?

It looks like Postgres user defined types are something else than ANSI SQL - so CREATE TYPE and DROP TYPE did different work.

In the section DROP TYPE in ANSI SQL there is not mentioned any relation to domains.


David J.

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: [Proposal] Global temporary tables
Next
From: Magnus Hagander
Date:
Subject: Re: recovering from "found xmin ... from before relfrozenxid ..."