[GENERAL] Escape variable

2016-10-27 Thread Jaime Rivera
Hello, I've been looking for a way to escape a variable inside a plpgsql stored procedure just like E works with constants. For example : * select E'Se recibi\u00f3 a \n ci\u00f3n.' * Returns: *Se recibió a * * ción.* Thanks Jaime

[GENERAL] Triggers not being fired with pglogical

2016-05-31 Thread Jaime Rivera
Hi, I have a basic replica with pglogical 1.1 and postgres 9.5 on both servers publisher and subscriber. I have triggers on publisher and subscriber tables, but the trigger on subscriber table is not being fired. Is it possible to fire the trigger with pglogical replication? Thanks in advance