BUG #10989: log_statement = ddl does not log ddl statements from stored functions

From: eshkinkot(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #10989: log_statement = ddl does not log ddl statements from stored functions
Date: 2014-07-18 12:29:34
Message-ID: 20140718122934.2494.28264@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 10989
Logged by: Sergey Burladyan
Email address: eshkinkot(at)gmail(dot)com
PostgreSQL version: 9.3.4
Operating system: Debian testing
Description:

If I run DROP directly, it logged:
drop view test_view ;
2014-07-18 16:20:51 MSK LOG: statement: drop view test_view ;

but this query is not:
do $$ begin execute 'drop view test_view'; end $$;

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Marc Schablewski 2014-07-18 15:13:10 PG 9.3.x: Dropping a table column breaks restore of dump if table is used as return type of a function used in a view
Previous Message Peter Eisentraut 2014-07-18 04:46:38 Re: BUG #10794: psql sometimes ignores .psqlrc