DELETE FROM pg_class

From: "Dawid Kuroczko" <qnex42(at)gmail(dot)com>
To: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: DELETE FROM pg_class
Date: 2007-09-24 12:44:32
Message-ID: 758d5e7f0709240544j19471899k6996a816ed1aebff@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello, I see that I can modify system tables even though I have
not set allow_system_table_mods... Is this a feature or a bug?

Self contained code

postgres=# SELECT version();
version
---------------------------------------------------------------------------------------------------------------
PostgreSQL 8.2.4 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.1.3
20070718 (prerelease) (Debian 4.1.2-14)
(1 row)

postgres=# SHOW allow_system_table_mods;
allow_system_table_mods
-------------------------
off
(1 row)

postgres=# CREATE DATABASE foo;
CREATE DATABASE
postgres=# \c foo
You are now connected to database "foo".
foo=# DELETE FROM pg_class;
DELETE 204
foo=# SELECT count(*) FROM pg_class;
ERROR: could not find pg_class tuple for index 2662
foo=# \c postgres
You are now connected to database "postgres".
postgres=# \c foo
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
Previous connection kept
postgres=#

Regards,
Dawid

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rodrigo De Le� 2007-09-24 13:17:37 Re: Best practice for specifying an interval
Previous Message Scott Marlowe 2007-09-24 12:40:05 Re: ERROR: must be superuser to alter superusers