On 6 March 2012 21:04, Dimitri Fontaine <dimi...@2ndquadrant.fr> wrote: >>> [CASCADE will not run the command triggers for cascaded objects] >> If these are all expected, does it in any way compromise the >> effectiveness of DDL triggers in major use-cases? > > I don't think so. When replicating the replica will certainly drop the > same set of dependent objects, for example. Auditing is another story. > Do we want to try having cascaded object support in drop commands?
I wasn't sure if auditing was one of the rationale behind the feature or not. If it is, it presents a major problem. How does the replica know that the objects were dropped? Thanks for the updated patch and the quick turnaround time. I'll give it another review. -- Thom -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers