2012/4/20 Tom Lane <tgl@xxxxxxxxxxxxx>: > Vincenzo Romano <vincenzo.romano@xxxxxxxxxxx> writes: >> 2012/4/20 Vincenzo Romano <vincenzo.romano@xxxxxxxxxxx>: >>> 2012/4/20 Tom Lane <tgl@xxxxxxxxxxxxx>: >>>> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
