Re: Rebuild pg_toast from scratch?

Поиск
Список
Период
Сортировка
От Moreno Andreo
Тема Re: Rebuild pg_toast from scratch?
Дата
Msg-id 6b26ee91-101c-b260-3d25-5147069620b4@evolu-s.it
обсуждение исходный текст
Ответ на Re: Rebuild pg_toast from scratch?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Rebuild pg_toast from scratch?
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: postgresql: Help with hstore hextension
Следующее
От: Lele Gaifax
Дата:
Сообщение: Re: Cannot restore dump when using IS DISTINCT FROM on a HSTORE column