Re: and it's not a bunny rabbit, either

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Robert Haas <robertmhaas@gmail.com>, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, Itagaki Takahiro <itagaki.takahiro@gmail.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2010-12-29T20:01:10Z
Lists: pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Excerpts from Tom Lane's message of mi dic 29 16:29:45 -0300 2010:
>> In practice I think it would make sense if heap_open accepts all
>> relation types on which you can potentially do either a heapscan or
>> indexscan (offhand those should be the same set of relkinds, I think;
>> so this is the same in effect as Heikki's proposal, but phrased
>> differently).  So it would have to start rejecting views, and we'd need
>> to go looking for the consequences of that.

> This seems a very good idea, but I think we shouldn't let it sink the
> current patch.

No, but possibly regularizing what heap_open is defined to do would make
Robert's patch simpler.

			regards, tom lane