| From: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Database synchronization |
| Date: | 2007-07-31 13:36:19 |
| Message-ID: | 20070731133619.GB8583@phlogiston.dyndns.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Tue, Jul 31, 2007 at 09:22:04AM +0100, Richard Huxton wrote:
> I don't think slony lets you rename tables/schemas during transfer. I'm
> not sure many people want it, and it would be a complicated thing to do
> properly in the general case (you'll need to consider dependant objects
> - FKeys, views, functions etc).
It doesn't allow this, but you could cause it to happen anyway on the
replica using a trigger. You have to use STORE TRIGGER to make this
work.
A
--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
The whole tendency of modern prose is away from concreteness.
--George Orwell
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Joseph Krogh | 2007-07-31 17:30:51 | Alternative to INTERSECT |
| Previous Message | Dmitry Turin | 2007-07-31 13:08:23 | Re: calling webservice through postgresql function |