Re: Create DDL trigger to catch which column was altered

2018-07-10 Thread Adrian Klaver
On 07/10/2018 01:56 AM, Łukasz Jarych wrote: It is no possible? AFAIK it is not possible, per: https://www.postgresql.org/message-id/3385.1518828768%40sss.pgh.pa.us Jacek -- Adrian Klaver adrian.kla...@aklaver.com

Re: Create DDL trigger to catch which column was altered

2018-07-10 Thread Łukasz Jarych
It is no possible? Jacek pon., 9 lip 2018 o 13:38 Łukasz Jarych napisał(a): > Hi Guys, > > i am using sqls like below to track ddl changes: > > CREATE TABLE track_ddl >> ( >> event text, >> command text, >> ddl_time timestamptz, >> usr text >> ); >> CREATE OR REPLACE FUNCTION track_ddl_

Create DDL trigger to catch which column was altered

2018-07-09 Thread Łukasz Jarych
Hi Guys, i am using sqls like below to track ddl changes: CREATE TABLE track_ddl > ( > event text, > command text, > ddl_time timestamptz, > usr text > ); > CREATE OR REPLACE FUNCTION track_ddl_function() > RETURNS event_trigger > AS > $$ > BEGIN > INSERT INTO track_ddl values(tg_tag, t