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. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers