Re: dbmirror - migration to 8.3 from 7.4

Поиск
Список
Период
Сортировка
От Claus Guttesen
Тема Re: dbmirror - migration to 8.3 from 7.4
Дата
Msg-id b41c75520805070449s3736dfbay4e27a0488e47f7f0@mail.gmail.com
обсуждение исходный текст
Ответ на dbmirror - migration to 8.3 from 7.4  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Ответы Re: dbmirror - migration to 8.3 from 7.4  ("Claus Guttesen" <kometen@gmail.com>)
Re: dbmirror - migration to 8.3 from 7.4  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Список pgsql-sql
> 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 noticed that some columns have been added to pg_index : indisvalid, indcheckxmin, indisready,indoption
> Should i include any of them (e.g. indisvalid) in the where clause above?

Do you use oid? We had an issue where old code relied on oid and when
we tested 8.2 we had issues with oid being used but not available. The
fix was easy and only required a id-column of type serial.

-- 
regards
Claus

When lenity and cruelty play for a kingdom,
the gentlest gamester is the soonest winner.

Shakespeare


В списке pgsql-sql по дате отправления:

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: dbmirror - migration to 8.3 from 7.4
Следующее
От: "Claus Guttesen"
Дата:
Сообщение: Re: dbmirror - migration to 8.3 from 7.4