Στις Wednesday 07 May 2008 14:49:31 ο/η Claus Guttesen έγραψε:
> > we have been running our own heavily modified/enhanced version of dbmirror,
> > running on 7.4 for some years,
> > and now it is the time to upgrade to 8.3.
> >
> > The way i find the primary key of a table is:
> >SELECT in
>> The way i find the primary key of a table is:
>>SELECT indkey FROM pg_index WHERE indisprimary='t' AND
>> indrelid=TABLEOID;
>> i noticed that some columns have been added to pg_index : indisvalid,
>> indcheckxmin, indisready,indoption
>> Should i include any of them (e.g. indisvalid)
> we have been running our own heavily modified/enhanced version of dbmirror,
> running on 7.4 for some years,
> and now it is the time to upgrade to 8.3.
>
> The way i find the primary key of a table is:
>SELECT indkey FROM pg_index WHERE indisprimary='t' AND
> indrelid=TABLEOID;
> i not
Hi,
we have been running our own heavily modified/enhanced version of dbmirror,
running on 7.4 for some years,
and now it is the time to upgrade to 8.3.
We have called our approach "Conditional row grained + FK dependency oriented
lazy replication", that is,
any FK dependencies of a row are tran
