On 2/19/13 5:22 PM, David Fetter wrote:
> On Tue, Feb 19, 2013 at 11:09:13PM +0100, Erik Rijkers wrote:
>> On Sat, February 16, 2013 02:01, Kevin Grittner wrote:
>>> matview-v4.patch.gz
>>
>> Hi,
>>
>> I was wondering if material views should not go into information_schema. I was thinking either
>> .views or .tables. Have you considered this?
>
> I'm guessing it'd be .views if anything. Haven't been able to
> decipher from section 11 of the standard (Schemata) whether the
> standard has anything to say on the matter.
I suppose one should be able to expect that if one finds a view in the
information schema, then one should be able to use DROP VIEW to remove
it. Which in this case wouldn't work. So I don't think including a
materialized view under views or tables is appropriate.