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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
