2012/4/20 Tom Lane <[email protected]>: > Vincenzo Romano <[email protected]> writes: >> 2012/4/20 Vincenzo Romano <[email protected]>: >>> 2012/4/20 Tom Lane <[email protected]>: >>>> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
