Re: Obtaining information on the schema of tables which - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: Obtaining information on the schema of tables which
Date
Msg-id 10809.1134630815@sss.pgh.pa.us
Whole thread Raw
In response to Re: Obtaining information on the schema of tables which  (Daniel Ariel <pgsqlinterfaces@netzach.co.il>)
Responses Re: Obtaining information on the schema of tables which
Re: Obtaining information on the schema of tables which
List pgsql-interfaces
Daniel Ariel <pgsqlinterfaces@netzach.co.il> writes:
> Is the required work to update to SQL2003 merely an update of the SQL of
> the views in information_schema ? If it would expedite matters I would
> be willing to help modify the SQL accordingly.

Possibly that's all that's needed, or maybe we need some changes to the
C-code functions that provide the protection-checking infrastructure for
the information_schema views.  The first step is to analyze exactly what
changed between the SQL99 and SQL2003 definitions of these views, and
then look at how this ought to fit in with Postgres' security features
(which are not 100% identical to what the spec thinks...).  If you've
got some time to spend on this, by all means hop aboard.
        regards, tom lane


pgsql-interfaces by date:

Previous
From: Daniel Ariel
Date:
Subject: Re: Obtaining information on the schema of tables which
Next
From: Daniel Ariel
Date:
Subject: Re: Obtaining information on the schema of tables which