Hi:

I have a plpgsql function that has this...

    drop table if exists tmp_diff_blkviews;

Even with the "if exists", I still get...

NOTICE:  table "tmp_diff_blkviews" does not exist, skipping
CONTEXT:  SQL statement "drop table if exists tmp_diff_blkviews"
PL/pgSQL function dvm.blkview_diffs(character varying,character varying)
line 6 at SQL statement

I want to suppress that.   Even if the temp table exists, I don't want to
hear about how it had to delete the table.  Just delete it if it exists and
be quiet about it.

This function is being called through perl/dbi. So client side command line
set options, or anything like that, is no good.  Is there  way to control
messaging from inside the function ?

Reply via email to