Re: BUG #4817: Dump of 8.3 hstore not restorable to 8.4 (RECHECK)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #4817: Dump of 8.3 hstore not restorable to 8.4 (RECHECK)
Дата
Msg-id 20073.1243375710@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #4817: Dump of 8.3 hstore not restorable to 8.4 (RECHECK)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
I wrote:
> If we remove the RECHECK printout then this will stop being true ---
> and worse, it will break silently and in a way that will only cause
> you to get occasional wrong answers from your queries.

But actually, that only says it's a bad idea to drop RECHECK from the
pg_dump output.  It doesn't say that an 8.4 server has to throw error
when it sees RECHECK.  The way things are set up now, ignoring it seems
fairly failsafe.  The default assumption in 8.4 is that operators are
lossy, so the worst case consequence is that you waste cycles on
unnecessary rechecks.  You don't get wrong answers, even if you
neglected to update your opclass support code.

Off to make a proposal to pghackers ...

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #4817: Dump of 8.3 hstore not restorable to 8.4 (RECHECK)
Следующее
От: "Herbert Bonaffini"
Дата:
Сообщение: BUG #4825: Before installation the server not running