postgresql-7.4RC1 - unrecognized privilege type when selecting from information_schema.tables - Mailing list pgsql-bugs

From
Subject postgresql-7.4RC1 - unrecognized privilege type when selecting from information_schema.tables
Date
Msg-id 20031108025712.47936.qmail@web40907.mail.yahoo.com
Whole thread Raw
Responses Re: postgresql-7.4RC1 - unrecognized privilege type when selecting from information_schema.tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
To produce the error, the following query was issued:

   select * from information_schema.tables;

Generates the following error message:

   ERROR:  unrecognized privilege type: "RERERENCES"

Replacing the word "RERERENCES" with "REFERENCES" in
the predicate "has_table_privilege(c.oid,
'RERERENCES'::text)" near the end of the view SQL
seems to correct the problem.


Thanks,
Ben

__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree

pgsql-bugs by date:

Previous
From: Thomas Erskine
Date:
Subject: before trigger doesn't, on insert of too long data
Next
From: Robert Grabowski
Date:
Subject: suggest: change alter user set search_path to raise notice not error