Re: [SQL] Lost my tablespace

On 05/29/2017 11:21 AM, tel medola wrote:
> As to below:
> 
> 1) In the below you are saying that you used that template to try to 
> recreate the original tables, correct?
> 
> /No.I have not done anything yet to try to retrieve the information, 
> even though they are there. I just can not redo the links, even with the 
> inherit command already executed./

It seems you are doing something, that is what I am trying figure out.
What INHERIT command?

Also can you show in psql:

\d+ (The tables involved)

> 
> 2) Why the INHERIT/NO INHERIT/INHERIT sequence?
> 
> /Because if I do not undo the inheritance, it will copy from it, to 
> itself. After the copy is finished and I make sure everything is in 
> place, I delete the original table and redo the links. With this, all my 
> data is a new drive and with the link redone, my SQL's will function 
> normally as if it were just a table./

But none of this was actually done when you tried to recover the tables.

> 
> 3) If 1) is correct did the COPY actually do anything?
> 
> /I only do this when I move my data to a new drive./



-- 
Adrian Klaver
adrian.klaver@aklaver.com