Re: Rebuild pg_toast from scratch? - Mailing list pgsql-general

From Moreno Andreo
Subject Re: Rebuild pg_toast from scratch?
Date
Msg-id 6b26ee91-101c-b260-3d25-5147069620b4@evolu-s.it
Whole thread Raw
In response to Re: Rebuild pg_toast from scratch?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Rebuild pg_toast from scratch?
List pgsql-general
Hi Tom and thanks for your time,

Il 05/09/19 15:53, Tom Lane ha scritto:
> Moreno Andreo <moreno.andreo@evolu-s.it> writes:
>>       I have an issue with a Windows 10 PC with Postgres 9.1 x86.
> You realize 9.1 is long out of support ...
Absolutely :-)
I'm about to migrate it to 11
> Now I need to recreate an empty copy of this table (data can be
> recovered later), how can I achieve this?
> TRUNCATE ought to be enough.
truncate pg_toast_49713;

ERROR: relation "pg_toast_49713" does not exist

:-\
... or do I need to truncate the "master" table (the table blobs are in)?

Thanks




pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgresql: Help with hstore hextension
Next
From: Lele Gaifax
Date:
Subject: Re: Cannot restore dump when using IS DISTINCT FROM on a HSTORE column