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

[Greg Stark]

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_sch ema.tables;
ERROR: unrecognized privilege type: "RERERENCES "

db=> \d information_sch ema.tables
View "information_sc hema.tables"
Column | Type | Modifiers
------------------------------+-----------------------------------+-----------
table_catalog | information_sch ema.sql_identif ier |
table_schema | information_sch ema.sql_identif ier |
table_name | information_sch ema.sql_identif ier |
table_type | information_sch ema.character_d ata |
self_referencin g_column_name | information_sch ema.sql_identif ier |
reference_gener ation | information_sch ema.character_d ata |
user_defined_ty pe_catalog | information_sch ema.sql_identif ier |
user_defined_ty pe_schema | information_sch ema.sql_identif ier |
user_defined_na me | information_sch ema.sql_identif ier |
View definition:
SELECT current_databas e()::character varying::inform ation_schema.sq l_identifier AS table_catalog, nc.nspname::cha racter varying::inform ation_schema.sq l_identifier AS table_schema, c.relname::char acter varying::inform ation_schema.sq l_identifier AS table_name,
CASE
WHEN nc.nspname ~~ like_escape('pg !_temp!_%'::tex t, '!'::text) THEN 'LOCAL TEMPORARY'::tex t
WHEN c.relkind = 'r'::"char" THEN 'BASE TABLE'::text
WHEN c.relkind = 'v'::"char" THEN 'VIEW'::text
ELSE NULL::text
END::informatio n_schema.charac ter_data AS table_type, NULL::informati on_schema.sql_i dentifier::info rmation_schema. sql_identifier AS self_referencin g_column_name, NULL::informati on_schema.chara cter_data::info rmation_schema. character_data AS reference_gener ation, NULL::informati on_schema.sql_i dentifier::info rmation_schema. sql_identifier AS user_defined_ty pe_catalog, NULL::informati on_schema.sql_i dentifier::info rmation_schema. sql_identifier AS user_defined_ty pe_schema, NULL::informati on_schema.sql_i dentifier::info rmation_schema. sql_identifier AS user_defined_na me
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_privi lege(c.oid, 'SELECT'::text) OR has_table_privi lege(c.oid, 'INSERT'::text) OR has_table_privi lege(c.oid, 'UPDATE'::text) OR has_table_privi lege(c.oid, 'DELETE'::text) OR has_table_privi lege(c.oid, 'RULE'::text) OR has_table_privi lege(c.oid, 'RERERENCES'::t ext) OR has_table_privi lege(c.oid, 'TRIGGER'::text ));
Note the "RERERENCES " in the last line of the view definition.
--
greg
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

[Tom Lane]

Greg Stark <gs*****@mit.ed u> writes:

... I'm actually still using 7.4 beta 5.
Naughty naughty.
db=> select table_name from information_sch ema.tables;
ERROR: unrecognized privilege type: "RERERENCES "

Works for me in REL7_4 CVS tip. You could dig in the committers
archives or release notes to see when it was fixed.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Manfred Koizar]

On 04 Jun 2004 01:31:05 -0400, Greg Stark <gs*****@mit.ed u> wrote:

using 7.4 beta 5. IIRC that was the last beta before the release and there
were no changes for 7.4.
But there were changes between 7.4 and 7.4.2 ;-) And I believe that
this fix is one of them.
db=> \d information_sch ema.tables
[...]
Note the "RERERENCES " in the last line of the view definition.

This is fixed in current sources.

Servus
Manfred

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

[Greg Stark]

Tom Lane <tg*@sss.pgh.pa .us> writes:

Greg Stark <gs*****@mit.ed u> writes:

... I'm actually still using 7.4 beta 5.

Naughty naughty.

Yeah, actually I didn't realize I was behind. I think I was behind because
Debian wanted to update perl in order to upgrade the perl pg driver and...

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

Works for me in REL7_4 CVS tip. You could dig in the committers
archives or release notes to see when it was fixed.

Anyways, I just updated and it's gone, but since I had already fixed the view
definition before upgrading that doesn't really prove anything.

7.4.1 does say:

* Fix information schema view constraint_colu mn_usage for foreign
keys (Peter)

Which I presume covered this.

--
greg
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)