Accidentally truncated pg_type - Mailing list pgsql-general

From Matthew Byrne
Subject Accidentally truncated pg_type
Date
Msg-id 629a197dca0a159c8c432b6fbae0017b.squirrel@localhost
Whole thread Raw
Responses 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>)
List 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 by date:

Previous
From: "David Johnston"
Date:
Subject: ? about Composite Keys + ON DELETE/UPDATE SET NULL
Next
From: hyelluas
Date:
Subject: Concurrent read from a partition table.