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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: bvctravel(at)yahoo(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: postgresql-7.4RC1 - unrecognized privilege type when selecting from information_schema.tables
Date: 2003-11-08 20:46:15
Message-ID: 14377.1068324375@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

<bvctravel(at)yahoo(dot)com> writes:
> 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2003-11-08 20:47:30 Re: suggest: change alter user set search_path to raise notice not error
Previous Message Bruce Momjian 2003-11-08 20:34:38 Re: pg_dumpall does not save CREATE permission on databases

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-11-08 20:56:12 Re: [HACKERS] postgresql-7.4RC1 - unrecognized privilege type
Previous Message Tom Lane 2003-11-08 20:19:43 Re: Making PostgreSQL 7.4 (CVS) work properly on OS X 10.3 (7B85)