dbTalk Databases Forums  

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

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] postgresql-7.4RC1 - unrecognized privilege type when selecting from information_schema.tables in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
 
Posts: n/a

Default [BUGS] postgresql-7.4RC1 - unrecognized privilege type when selecting from information_schema.tables - 11-08-2003 , 02:31 PM







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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply With Quote
  #2  
Old   
Tom Lane
 
Posts: n/a

Default Re: [BUGS] postgresql-7.4RC1 - unrecognized privilege type when selecting from information_schema.tables - 11-08-2003 , 02:51 PM






<bvctravel (AT) yahoo (DOT) com> writes:
Quote:
select * from information_schema.tables;
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.
Good catch. There are two other places with the same typo :-( (all
copied and pasted no doubt).

I've applied the patch but am loathe to force an initdb this late in
the beta cycle. Any opinions out there?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.