Skip site navigation (1) Skip section navigation (2)

Re: Dropped index on table preventing rule creation

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Thom Brown <thom(at)linux(dot)com>, pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Dropped index on table preventing rule creation
Date: 2011-09-15 10:42:46
Message-ID: CA+TgmobOEbRcZLn6fRYfTa=R1KCp8ZfPBiEPMzsA-wLS4p-8eQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Wed, Sep 14, 2011 at 10:58 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Yeah, that's about what it would take, but what I'm asking is why
> bother.  The *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).  See 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.

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

In response to

pgsql-bugs by date

Next:From: Robert HaasDate: 2011-09-15 11:26:00
Subject: Re: BUG #6193: The one-click installer failed to unpack
Previous:From: Thomas KellererDate: 2011-09-15 08:18:32
Subject: Re: Problem with the 9.1 one-click installer Windows7 64bit

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group