Re: BUG #19383: Server crash at getmissingattr

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #19383: Server crash at getmissingattr
Дата
Msg-id 1538113.1768921841@sss.pgh.pa.us
обсуждение
Ответ на BUG #19383: Server crash at getmissingattr  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> create table foo(a int);
> DROP TABLE IF EXISTS l_prijscomponent_eenheid CASCADE;
> insert into foo values(1),(2),(3);
> alter table foo add b int not null default 0;
> update pg_attribute set attmissingval = NULL where attname = 'b';
> select b from foo;

This is not a bug.  This is a superuser intentionally breaking
the system by corrupting the catalogs.  There are any number
of ways to cause trouble with ill-advised manual updates to a
catalog table.  Try, eg, "DELETE FROM pg_proc" (... but not in
a database you care about).

            regards, tom lane



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