Re: Views, views, views! (long)

> -----Original Message-----
> From: Josh Berkus [mailto:josh(at)agliodbs(dot)com]
> Sent: Thursday, May 05, 2005 5:35 PM
> To: Dann Corbit
> Cc: elein; PostgreSQL-development; Peter Eisentraut
> Subject: Re: [HACKERS] Views, views, views! (long)
>
> Dann,
>
> > 1.  There is not a whole lot of stuff that cannot be directly stored in
> > the INFORMATION_SCHEMA location without modifying it.
>
> See Andrew's post. There is a whole lot of stuff not covered by I_S in a
> way
> that is useful to PGSQL users. Also this would require making
> information_schema part of the default user path.

It is supposed to be part of the default user path for all users of the database.

> > 2.  Almost all of the information that cannot fit will be useful to
> > other database systems as well, and should be suggested to the ANSI/ISO
> > committee.  Since INFORMATION_SCHEMA is a very new idea (only two
> > adopters that I know of so far) I expect it will need to grow and
> > PostgreSQL could be one of the contributors.  Whether the enhancements
> > are accepted or not, it would be good to at least attempt to get them
> > noticed.
>
> I like that idea, actually.
>
> However, there's not a whelk's chance in a supernova of our suggestions
> getting read, let alone accepted. But we could make the effort. You
> volunteering?

It's probably like ANSI/ISO C and C++ committees -- they only listen if you actually show up to the meetings. I doubt if I could pay to go and attend in person. Maybe some of the Redhat people can, since they maintain the Redhat database.

For sure, if the DB/2 or Oracle or MS or ... people hear about it and see that it is a good idea, they will push for it also. Otherwise, the competitors who adopt it will have a competitive advantage.

> > 3.  Of the fragment that does not fall under 1 and 2, it should be a
> > carefully documented extension that lives in the same place
> > (INFORMATION_SCHEMA) so that we know where to look to find it.
>
> --
> --Josh
>
> Josh Berkus
> Aglio Database Solutions
> San Francisco