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 по дате отправления: