Re: [SQL] Lost my tablespace

Поиск
Список
Период
Сортировка
От tel medola
Тема Re: [SQL] Lost my tablespace
Дата
Msg-id CANRMYmiSS2jBLXL1TMJwfJ3dpXuzO2BO6pQF3dKX=guor_u5og@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [SQL] Lost my tablespace  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-sql
Ok Adrian.
I' will asking pgsql-general list.

Very thanks for all help!

Em ter, 30 de mai de 2017 às 20:25, Adrian Klaver <adrian.klaver@aklaver.com> escreveu:
On 05/30/2017 01:36 PM, tel medola wrote:
> EXACT !!!!!
>
> When I did the truncate, it erased all the files that referenced the
> table and created a new one (empty). That's why when I returned the
> physical files to the drives, it does not find the old reference and it
> is empty.
>
> I'll search how to redo the link for the correct filenode.
> Thanks very much for your help!!!
>

Just so you know I am willing to ask how to do this on the pgsql-general
list if you want.


--
Adrian Klaver
adrian.klaver@aklaver.com

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [SQL] Lost my tablespace
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] Inconsistent/wrong behavior of pg_trigger_depth when used with DEFERRED CONSTRAINTS