Skip site navigation (1) Skip section navigation (2)

Re: constraints and sql92 information_schema compliance

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Bruno Wolff III <bruno(at)wolff(dot)to>, "Clark C(dot) Evans" <cce(at)clarkevans(dot)com>,pgsql-hackers(at)postgresql(dot)org
Subject: Re: constraints and sql92 information_schema compliance
Date: 2006-02-25 22:28:16
Message-ID: 20060225222816.GL82012@pervasive.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Sat, Feb 25, 2006 at 11:51:55AM -0800, Josh Berkus wrote:
> Bruno,
> 
> > This has been discussed previously in a couple of threads. I believe the
> > desire is to make it work as specified in SQL-2003, but I do not remember
> > whether or not anyone volunteered to do the work to make it happen.
> 
> I believe that the newsysviews follow the SQL03 permissions structure. 

Does SQL03 specify a different name for info schema? Should we morph
newsysviews to that?

Of course this still leaves the issue of how to deal with
PostgreSQL-specific stuff that isn't in infoschema, since we probably
don't want to be adding extra stuff there.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby(at)pervasive(dot)com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

In response to

pgsql-hackers by date

Next:From: James William PyeDate: 2006-02-25 22:47:16
Subject: Re: Pl/Python -- current maintainer?
Previous:From: Stephan SzaboDate: 2006-02-25 22:01:00
Subject: Re: constraints and sql92 information_schema compliance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group