2012/4/20 Tom Lane <t...@sss.pgh.pa.us>: > Vincenzo Romano <vincenzo.rom...@notorand.it> writes: >> 2012/4/20 Vincenzo Romano <vincenzo.rom...@notorand.it>: >>> 2012/4/20 Tom Lane <t...@sss.pgh.pa.us>: >>>> You might be able to use "DROP VIEW pg_temp.foo", which will either >>>> drop a temp view of your own session or throw an error if there is none. > >> It works only if you have created at least one temporary object. >> Until that the pg_temp "meta schema" doesn't resolve to a real schema >> and the exception is thrown! > > I didn't say *which* error would get thrown ;-). If you are checking > that you'd need to be prepared for both cases. > > regards, tom lane
... WHEN OTHERS THEN NULL should be pretty safe to DROP a VIEW! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general