Bug Report -- information schema view is broken 'unrecognized privilege type: "RERERENCES"'
От | Greg Stark |
---|---|
Тема | Bug Report -- information schema view is broken 'unrecognized privilege type: "RERERENCES"' |
Дата | |
Msg-id | 87wu2n3n52.fsf@stark.xeocode.com обсуждение исходный текст |
Ответы |
Re: Bug Report -- information schema view is broken 'unrecognized privilege type: "RERERENCES"'
(Tom Lane <tgl@sss.pgh.pa.us>)
Re: Bug Report -- information schema view is broken 'unrecognized privilege type: "RERERENCES"' (Manfred Koizar <mkoi-pg@aon.at>) |
Список | 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::charactervarying::information_schema.sql_identifier AS table_schema, c.relname::character varying::information_schema.sql_identifierAS 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_identifierAS self_referencing_column_name, NULL::information_schema.character_data::information_schema.character_dataAS reference_generation, NULL::information_schema.sql_identifier::information_schema.sql_identifierAS user_defined_type_catalog, NULL::information_schema.sql_identifier::information_schema.sql_identifierAS user_defined_type_schema, NULL::information_schema.sql_identifier::information_schema.sql_identifierAS 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
В списке pgsql-general по дате отправления: