út 14. 7. 2020 v 16:09 odesílatel David G. Johnston < david.g.johns...@gmail.com> napsal:
> On Tue, Jul 14, 2020 at 6:56 AM Pavel Stehule <pavel.steh...@gmail.com> > wrote: > >> út 14. 7. 2020 v 15:55 odesílatel David G. Johnston < >> david.g.johns...@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. >