Search Postgresql Archives

suppress notices from inside a stored a plpgqsl function

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 ? 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux