From: Tom Lane <tgl@sss.pgh.pa.us>
To: Daniel Ariel <pgsqlinterfaces@netzach.co.il>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Obtaining information on the schema of tables which
Date: Thu, 15 Dec 2005 02:13:35 -0500
Message-ID: <10809.1134630815@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.LNX.4.58.0512150920040.3946@perpetual.jerusalem.plus.com>
References: <Pine.LNX.4.58.0512122253330.25426@perpetual.jerusalem.plus.com>
<20051214173955.GA9238@wolff.to>
<22357.1134583686@sss.pgh.pa.us>
<Pine.LNX.4.58.0512150920040.3946@perpetual.jerusalem.plus.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, pgsqlinterfaces@netzach.co.il
Subject: Re: Obtaining information on the schema of tables which
In-Reply-To: <10809.1134630815@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox