Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgadmin-hackerspgsql-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

pgsql-bugs by date

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

pgadmin-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group