Re: Dropped index on table preventing rule creation

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Dropped index on table preventing rule creation
Дата
Msg-id CA+TgmobOEbRcZLn6fRYfTa=R1KCp8ZfPBiEPMzsA-wLS4p-8eQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Dropped index on table preventing rule creation  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
On Wed, Sep 14, 2011 at 10:58 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Yeah, that's about what it would take, but what I'm asking is why
> bother. =A0The *only* case that we support here is turning a just-created,
> not-fooled-with table into a view, and I don't feel a need to promise
> that we will handle other cases (which are inevitably going to be poorly
> tested). =A0See for example the adjacent relhassubclass test, which has
> got exactly the same issue.
>
>> One related thing that seems worth doing is ripping out relhaspkey,
>
> Having a hard time getting excited about that either ...

The fact that this code is poorly tested is exactly why I don't think
we should be complicating it with doodads of doubtful utility.  The
existence of these Booleans causes people to use them.  This probably
doesn't save any appreciable amount of performance, but it does make
it easier to write wrong code.

--=20
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: BUG #6207: fali to get lock on parent table after two consecutive updates to the same row in child table
Следующее
От: Robert Haas
Дата:
Сообщение: Re: BUG #6193: The one-click installer failed to unpack