Re: [HACKERS] External Replication

2012-09-24 Thread Dimitri Fontaine
m...@rpzdesign.com m...@rpzdesign.com writes: You may want to consider changing the command TRIGGER into a command FILTER and possibly post processing TRIGGER that is determined to be called INSIDE the FILTER. Or some way to pass information between the FILTER and the post processing trigger.

Re: [HACKERS] External Replication

2012-09-24 Thread m...@rpzdesign.com
Dmitri: Thanks for the response. I am resigned to just patch each major release with my own pile of hook code that I can quickly graft into the code base, currently grafting 9.2.0. My strategy is to let the PG code base float around with all the work of the fine hackers on this list, maybe

Re: [HACKERS] External Replication

2012-09-24 Thread Alvaro Herrera
Excerpts from m...@rpzdesign.com's message of lun sep 24 14:24:31 -0300 2012: And I have not seen anybody request my hook code but a few have responded that the are working on things in the code base, release date unknown. Well, typically that's not how our development works -- people here

Re: [HACKERS] External Replication

2012-09-22 Thread m...@rpzdesign.com
Andres those involved in the 9.3 Command triggers: You may want to consider changing the command TRIGGER into a command FILTER and possibly post processing TRIGGER that is determined to be called INSIDE the FILTER. Or some way to pass information between the FILTER and the post processing

[HACKERS] External Replication

2012-09-21 Thread m...@rpzdesign.com
Heikki: Thanks for the response. I am writing an external replication engine and putting hooks into postgres to send signals via a unix socket to the outside world. All of the logic and implementation will occur OUTSIDE the postgres codebase and will not interfere with any WAL based

Re: [HACKERS] External Replication

2012-09-21 Thread Andres Freund
On Friday, September 21, 2012 08:12:26 PM m...@rpzdesign.com wrote: Heikki: Thanks for the response. I am writing an external replication engine and putting hooks into postgres to send signals via a unix socket to the outside world. All of the logic and implementation will occur OUTSIDE

Re: [HACKERS] External Replication

2012-09-21 Thread m...@rpzdesign.com
Andres: Thanks for the link on the GIT patch code. I did a big major domo search and found some stuff related to command triggers: http://archives.postgresql.org/pgsql-hackers/2012-03/msg00169.php Look into the new event triggers started recently. - Are these command triggers currently in

Re: [HACKERS] External Replication

2012-09-21 Thread Andres Freund
Hi, On Friday, September 21, 2012 11:06:46 PM m...@rpzdesign.com wrote: Thanks for the link on the GIT patch code. I did a big major domo search and found some stuff related to command triggers: http://archives.postgresql.org/pgsql-hackers/2012-03/msg00169.php Look into the new event