postgresql-7.4RC1 - unrecognized privilege type when selecting from information_schema.tables

From: <bvctravel(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: postgresql-7.4RC1 - unrecognized privilege type when selecting from information_schema.tables
Date: 2003-11-08 02:57:12
Message-ID: 20031108025712.47936.qmail@web40907.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers


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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas Erskine 2003-11-08 03:10:12 before trigger doesn't, on insert of too long data
Previous Message Josh Berkus 2003-11-07 23:53:22 Minor bug: Odd feedback on STDERR from PSQL for block comments

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2003-11-08 03:27:48 Re: What do you want me to do?
Previous Message Philip Warner 2003-11-08 02:46:45 Re: Information Schema and constraint names not