Re: [HACKERS] Logical decoding truncate

2017-05-11 Thread Euler Taveira
2017-05-11 4:23 GMT-03:00 Friedrich, Steffen < steffen.friedr...@dieboldnixdorf.com>: > I am writing a logical decoding output plugin decoding WAL to SQL which is > finally applied to target database. > > > > Is it possible to decode a TRUNCATE statement and the tables involved? > > Yes, use event

[HACKERS] Logical decoding truncate

2017-05-11 Thread Friedrich, Steffen
Hi, I am writing a logical decoding output plugin decoding WAL to SQL which is finally applied to target database. Is it possible to decode a TRUNCATE statement and the tables involved? Assuming the SQL statement "TRUNCATE x, y;", I am interested in decoding the operation TRUNCATE and the corr