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
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 |