DELETE FROM pg_class

Поиск
Список
Период
Сортировка
От Dawid Kuroczko
Тема DELETE FROM pg_class
Дата
Msg-id 758d5e7f0709240544j19471899k6996a816ed1aebff@mail.gmail.com
обсуждение исходный текст
Ответы Re: DELETE FROM pg_class
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: ERROR: must be superuser to alter superusers
Следующее
От: Niklas Johansson
Дата:
Сообщение: Re: full join question...