On 9/29/2004 2:51 PM, Alan Hodgson wrote:

> On Wed, Sep 29, 2004 at 07:09:37PM +0100, Richard Jones wrote:
>> Ideally, i would create another schema (eg called 'replicated_data') on 
>> the second machine, into which i'd replicate bits and pieces from the 
>> first database. Is this possible, or do i have to replicate the full 
>> table?
> 
> I don't think it's possible to do exactly what you want.

Since there is no data in a view (a view in PG is an empty relation with 
a rewrite rule on SELECT), I found it pretty obsolete to replicate them.

> 
> However, you could create another table on the master with just the fields
> you need, maintain it with triggers on the main table, and then replicate 
> just the new table.
> 

That would be the way to go. Especially because that trigger could check 
and suppress the update to the derived table if none of the relevant 
fields has changed.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #