From: Daniel Ariel <pgsqlinterfaces@netzach.co.il>
To: pgsql-interfaces@postgresql.org
Subject: Re: Obtaining information on the schema of tables which
Date: Thu, 15 Dec 2005 15:27:26 +0200 (IST)
Message-ID: <Pine.LNX.4.58.0512151516030.3946@perpetual.jerusalem.plus.com> (raw)
In-Reply-To: <10809.1134630815@sss.pgh.pa.us>
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>
<10809.1134630815@sss.pgh.pa.us>
OK, if I understand things correctly, comparing the
CONSTRAINT_COLUMN_USAGE view:
SQL2003 late draft:
WHERE ( SCHEMA_OWNER = CURRENT_USER
OR
SCHEMA_OWNER IN
( SELECT ROLE_NAME
FROM ENABLED_ROLES ) )
PG 7.4.7:
WHERE pg_class.relowner=pg_user.usesysid
AND pg_user.usename=current_user()
What PG should be, in order to meet the SQL2003 standard:
WHERE pg_class.relowner=pg_user.usesysid
AND (pg_user.usename=current_user() OR
pg_user IN (SELECT role_name FROM
information_schema.enabled_roles)
)
I cannot comment on other changes between SQL92 and 2003 until somebody
can point me in the direction of the SQL92 spec.
Please note that my quotes are based on the SQL as extracted from the
views in the database, not those in CVS.
Daniel
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: pgsqlinterfaces@netzach.co.il
Subject: Re: Obtaining information on the schema of tables which
In-Reply-To: <Pine.LNX.4.58.0512151516030.3946@perpetual.jerusalem.plus.com>
* 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