2013/11/11 Pavel Stehule <[email protected]> > > > > 2013/11/11 Tom Lane <[email protected]> > >> Andres Freund <[email protected]> writes: >> > Turns out that's bogus - ALTER TABLE has two levels of NOT EXISTS. >> >> > Maybe we should just do the same for DROP TRIGGER? >> >> > DROP TRIGGER [ IF EXISTS ] name ON table_name [ IF EXISTS ] [ CASCADE | >> RESTRICT ] >> > This syntax is not consistent with other IF EXISTS.
should be (IF EXISTS is before name always) DROP TRIGGER [ IF EXISTS ] name ON [ IF EXISTS ] table_name [ CASCADE | RESTRICT ] What do you think about? Regards Pavel > >> Works for me. >> > > for me too > > tomorrow I'll prepare patch > > Regards > > Pavel > > >> >> regards, tom lane >> >> >> -- >> Sent via pgsql-hackers mailing list ([email protected]) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-hackers >> > >
