Accidentally truncated pg_type

Поиск
Список
Период
Сортировка
От Matthew Byrne
Тема Accidentally truncated pg_type
Дата
Msg-id 629a197dca0a159c8c432b6fbae0017b.squirrel@localhost
обсуждение исходный текст
Ответы Re: Accidentally truncated pg_type  (Craig Ringer <craig@postnewspapers.com.au>)
Re: Accidentally truncated pg_type  (Craig Ringer <craig@postnewspapers.com.au>)
Re: Accidentally truncated pg_type  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-general
I have a large database full of irreplaceable data, and due to a
ridiculous happenstance I accidentally executed this code (as a superuser,
of course):

DELETE FROM pg_catalog.pg_type;

Now the database is *seriously* unhappy - every SQL command returns an
error message.  How do I get at my data?

Regards,

Matt

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

Предыдущее
От: "David Johnston"
Дата:
Сообщение: ? about Composite Keys + ON DELETE/UPDATE SET NULL
Следующее
От: hyelluas
Дата:
Сообщение: Concurrent read from a partition table.