Bug Report -- information schema view is broken 'unrecognized privilege type: "RERERENCES"'

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Bug Report -- information schema view is broken 'unrecognized privilege type: "RERERENCES"'
Date: 2004-06-04 05:31:05
Message-ID: 87wu2n3n52.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I haven't seen it mentioned, but I could have missed it. It seems like this
kind of thing must be known and probably fixed already? I'm actually still
using 7.4 beta 5. IIRC that was the last beta before the release and there
were no changes for 7.4.

db=> select table_name from information_schema.tables;
ERROR: unrecognized privilege type: "RERERENCES"

db=> \d information_schema.tables
View "information_schema.tables"
Column | Type | Modifiers
------------------------------+-----------------------------------+-----------
table_catalog | information_schema.sql_identifier |
table_schema | information_schema.sql_identifier |
table_name | information_schema.sql_identifier |
table_type | information_schema.character_data |
self_referencing_column_name | information_schema.sql_identifier |
reference_generation | information_schema.character_data |
user_defined_type_catalog | information_schema.sql_identifier |
user_defined_type_schema | information_schema.sql_identifier |
user_defined_name | information_schema.sql_identifier |
View definition:
SELECT current_database()::character varying::information_schema.sql_identifier AS table_catalog, nc.nspname::character varying::information_schema.sql_identifier AS table_schema, c.relname::character varying::information_schema.sql_identifier AS table_name,
CASE
WHEN nc.nspname ~~ like_escape('pg!_temp!_%'::text, '!'::text) THEN 'LOCAL TEMPORARY'::text
WHEN c.relkind = 'r'::"char" THEN 'BASE TABLE'::text
WHEN c.relkind = 'v'::"char" THEN 'VIEW'::text
ELSE NULL::text
END::information_schema.character_data AS table_type, NULL::information_schema.sql_identifier::information_schema.sql_identifier AS self_referencing_column_name, NULL::information_schema.character_data::information_schema.character_data AS reference_generation, NULL::information_schema.sql_identifier::information_schema.sql_identifier AS user_defined_type_catalog, NULL::information_schema.sql_identifier::information_schema.sql_identifier AS user_defined_type_schema, NULL::information_schema.sql_identifier::information_schema.sql_identifier AS user_defined_name
FROM pg_namespace nc, pg_class c, pg_user u
WHERE c.relnamespace = nc.oid AND u.usesysid = c.relowner AND (c.relkind = 'r'::"char" OR c.relkind = 'v'::"char") AND (u.usename = "current_user"() OR has_table_privilege(c.oid, 'SELECT'::text) OR has_table_privilege(c.oid, 'INSERT'::text) OR has_table_privilege(c.oid, 'UPDATE'::text) OR has_table_privilege(c.oid, 'DELETE'::text) OR has_table_privilege(c.oid, 'RULE'::text) OR has_table_privilege(c.oid, 'RERERENCES'::text) OR has_table_privilege(c.oid, 'TRIGGER'::text));

Note the "RERERENCES" in the last line of the view definition.

--
greg

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Ochs 2004-06-04 05:50:06 Re: Grant / Revoke functionality
Previous Message Jan Wieck 2004-06-04 05:01:19 Slony-I goes BETA