| From: | "Ed L(dot)" <pgsql(at)bluepolka(dot)net> |
|---|---|
| To: | "Gregory Wood" <gregw(at)com-stock(dot)com>, "PostgreSQL General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: replicating DDL statements |
| Date: | 2003-03-06 18:33:09 |
| Message-ID: | 200303061133.09355.pgsql@bluepolka.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thursday March 6 2003 11:25, Gregory Wood wrote:
> > I considered setting up triggers on Pgsql system tables to replicate
> > DDL statements and replicate those system row changes much like user
> > data, and to also use system table triggers to create replication
> > triggers for newly added tables. But user triggers are not allowed on
> > system tables, and I'm not sure it'd be reasonable or wise anyway.
> > Comments or other ideas?
>
> One potential problem you might run into is triggers on said added
> tables.
>
> I had to disable my user-made triggers on slave databases because ...
Anyone know if there a way to disable triggers for the current transaction?
Much like the "SET CONSTRAINTS ALL DEFERRED"? Is that doable?
Ed
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Emmanuel Charpentier | 2003-03-06 18:54:54 | [OT] : mailing list - news server gateway out of commission ? |
| Previous Message | Gregory Wood | 2003-03-06 18:25:49 | Re: replicating DDL statements |