Обсуждение: Friendly catalog views

On Wed, May 10, 2006 at 02:08:46PM -0300, Bruno Almeida do Lago wrote:
> Sometime ago I saw a project with the purpose of creating Oracle views over
> the PostgreSQL catalog.
>
> I can't remember/find it anymore. Do you know if it's still available?
>
> Is there any other project aiming to create friendly catalog views?

Not oracle views, but there is
http://pgfoundry.org/projects/newsysviews/ .
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

On Mon, 2006-05-15 at 17:12 -0500, Jim C. Nasby wrote:
> On Wed, May 10, 2006 at 02:08:46PM -0300, Bruno Almeida do Lago wrote:
> > Sometime ago I saw a project with the purpose of creating Oracle views over
> > the PostgreSQL catalog.
> >
> > I can't remember/find it anymore. Do you know if it's still available?
> >
> > Is there any other project aiming to create friendly catalog views?
>
> Not oracle views, but there is
> http://pgfoundry.org/projects/newsysviews/ .

This looks very interesting and useful... However, the documentation
notes that it was hoped to get included into 8.1, but I presume that it
didn't make it in there. Are there any indications as to whether it
might get included in 8.2?

--

Russ

On Mon, May 15, 2006 at 10:14:05PM -0500, Russ Brown wrote:
> On Mon, 2006-05-15 at 17:12 -0500, Jim C. Nasby wrote:
> > On Wed, May 10, 2006 at 02:08:46PM -0300, Bruno Almeida do Lago wrote:
> > > Sometime ago I saw a project with the purpose of creating Oracle views over
> > > the PostgreSQL catalog.
> > >
> > > I can't remember/find it anymore. Do you know if it's still available?
> > >
> > > Is there any other project aiming to create friendly catalog views?
> >
> > Not oracle views, but there is
> > http://pgfoundry.org/projects/newsysviews/ .
>
> This looks very interesting and useful... However, the documentation
> notes that it was hoped to get included into 8.1, but I presume that it
> didn't make it in there. Are there any indications as to whether it
> might get included in 8.2?

The history is that we developed it outside of the rest of the hacker
community and then got considerable push-back when we introduced it.
Since then we've gotten side-tracked on other things.

In a nutshell, the arguments were essentially about why we should have
this in addition to information_schema.

I think there might still be some opportunity to get this included if
the hacker community can reach some kind of consensus. I know one
prevalent opinion was that it should be made to more closely match the
naming conventions of information_schema.

Anyway, if users start finding use for this we'll have better grounds to
stand on for including it in the backend.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461