Hi,
I have an issue with a Windows 10 PC with Postgres 9.1 x86.
Running some SELECTs we got "ERROR: could not open file
"base/48121/784576": No such file or directory"
I then ran
select
n.nspname AS tableschema,
c.relname AS tablename
from pg_class c
inner join pg_namespace n on (c.relnamespace = n.oid)
where c.relfilenode = 784576;
and discovered that the involved table is pg_toast_49713.
Now I need to recreate an empty copy of this table (data can be
recovered later), how can I achieve this?
Thanks in advance
Moreno.-