Hello I am sending a patch that removes strict requirements for DROP IF EXISTS statements. This behave is similar to our ALTER IF EXISTS behave now.
postgres=# DROP CAST IF EXISTS (sss AS public.casttesttype); NOTICE: types "sss" and "public.casttesttype" does not exist, skipping DROP CAST postgres=# DROP FUNCTION IF EXISTS public.pt_in_widget(point, widget); NOTICE: function public.pt_in_widget(point,widget) does not exist, skipping DROP FUNCTION postgres=# DROP OPERATOR IF EXISTS public.<% (point, widget); NOTICE: operator public.<% does not exist, skipping DROP OPERATOR postgres=# DROP TRIGGER test_trigger_exists ON no_such_table; ERROR: relation "no_such_table" does not exist postgres=# DROP TRIGGER IF EXISTS test_trigger_exists ON no_such_table; NOTICE: trigger "test_trigger_exists" for table "no_such_table" does not exist, skipping DROP TRIGGER This functionality is necessary for correct quite reload from dump without possible warnings Regards Pavel 2013/7/2 Pavel Stehule <pavel.steh...@gmail.com>: > Hello > > remastered patch > > still there is a issue with dependencies > > Regards > > Pavel Stehule > > > > > 2013/6/17 Josh Kupershmidt <schmi...@gmail.com>: >> On Fri, Mar 8, 2013 at 11:58 AM, Pavel Stehule <pavel.steh...@gmail.com> >> wrote: >> >>> I'll see - please, stay tuned to 9.4 first commitfest >> >> Hi Pavel, >> Just a reminder, I didn't see this patch in the current commitfest. I >> would be happy to spend some more time reviewing if you wish to pursue >> the patch. >> >> Josh
drop-if-exists-no-double-check.patch
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers