Re: [HACKERS] Re: Mirroring a DB

From: Karl DeBisschop <kdebisschop(at)range(dot)infoplease(dot)com>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: peter_e(at)gmx(dot)net, hackers(at)postgreSQL(dot)org, swalton(at)galileo(dot)csun(dot)edu
Subject: Re: [HACKERS] Re: Mirroring a DB
Date: 1999-12-11 21:45:44
Message-ID: 199912112145.QAA03586@skillet.infoplease.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> I'm not the god of rules, but I have messed with that code. Current
> sources will put table prefixes on every var in a rule if more than one
> table appears in the rule's rangelist. I think this should be
> sufficient, but it's hard to tell from this incomplete example;
> are you actually complaining about some special case that arises when
> a column has the same name as its table?
>
> It would be nice to see the original view definition (plus enough table
> definitions to let us create the rule without guessing).
>
> regards, tom lane

I also looked back to double check versions. Unbeknownst to me, the
source database is 6.5.1 - the destination is 6.5.3

Version 6.5.3 seem to behave as you said, so I'm guessing that this
fix occurred relatively recently and I was just unaware it had been
fixed.

Karl

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 1999-12-11 22:04:10 createdb with alternate location
Previous Message Karl DeBisschop 1999-12-11 21:32:28 Re: [HACKERS] Re: Mirroring a DB