Re: public.pg_class isn't a catalog table

From: Dave Page <dpage(at)postgresql(dot)org>
To: "Decibel!" <decibel(at)decibel(dot)org>
Cc: pgadmin-hackers(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org
Subject: Re: public.pg_class isn't a catalog table
Date: 2007-09-06 08:21:41
Message-ID: 46DFB895.9090300@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgsql-bugs

Decibel! wrote:
> Version 1.6.3; if you have a table in public called pg_class and try to
> drop it, pgAdmin gives an error:
>
> ERROR: permission denied: "pg_class" is a system catalog
>
> The drop does work correctly from psql...

I'm sure you (Jim) have seen the reasons why this happens pgAdmin in the
rest of the thread, but I wonder also if this could be considered a bug
in the server:

foo=# create table pg_class(a text);
CREATE TABLE
foo=# drop table pg_class;
ERROR: permission denied: "pg_class" is a system catalog
foo=# drop table public.pg_class;
DROP TABLE
foo=#

It's certainly inconsistent.

/D

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2007-09-06 08:24:24 Re: Maintenance on indexes
Previous Message svn 2007-09-06 08:18:26 SVN Commit by dpage: r6615 - trunk/pgadmin3/pgadmin/schema

Browse pgsql-bugs by date

  From Date Subject
Next Message Unicode converter buffer overflow in psqlodbc driver 2007-09-06 09:23:56 BUG #3601: When we try to connect to postgres ti shows Unicode converter buffer overflow error.
Previous Message Dave Page 2007-09-06 08:15:04 Re: public.pg_class isn't a catalog table