Ranko.Mosic_at_gmail.com wrote:
> select count(*) from table on both nodes; if same they are in sync,
> Frank van Bortel wrote:
>> mike7411_at_gmail.com schreef:
>>> Is there an easy way to tell if a materialized view is in sync?
>>>
>>> Thank you.
>>>
>> Define in sync...
>> Until then: Probably not.
>>
>> --
>> Regards,
>> Frank van Bortel
>>
>> Top-posting is one way to shut me up...
>
Not really. If a row changed in the base table, the counts could still
match but the data would be different.
Received on Mon Jul 31 2006 - 15:57:27 CDT
