"Dean" <[EMAIL PROTECTED]> writes:
> If I create a function which relies on the undefined_table exception to test
> if a table exists, it does not behave as expected.
Try issuing the DELETE via EXECUTE --- you're getting burnt by plan
caching.
But actually, do you really want something as destructive as DELETE
for an existence probe? I'd try
PERFORM 'bar'::text::regclass;
and see if that throws an error. (The double cast is important here,
so that you get a runtime lookup not a compile-time one.)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
