Now the patch looks good to me. However when I try to restore your own sql file's dump, I get following errors:
pg_restore: [archiver (db)] could not execute query: ERROR: relation "public.emp" does not exist Command was: DROP TRIGGER IF EXISTS emp_insert_trigger ON public.emp;
pg_restore: [archiver (db)] could not execute query: ERROR: schema "myschema" does not exist Command was: DROP FUNCTION IF EXISTS myschema.int_to_date(integer);
Is that expected after your patch ?
Also, I didn't quite understand these lines of comments:
/* * Descriptor string (te-desc) should not be same as object * specifier for DROP STATEMENT. The DROP DEFAULT has not * IF EXISTS clause - has not sense. */
Will you please rephrase ?
Thanks
--
Jeevan B Chalke Principal Software Engineer, Product Development EnterpriseDB Corporation The Enterprise PostgreSQL Company