Re: Redo the filenode link in tablespace

On 06/06/2017 04:40 AM, tel medola wrote:
> Lets go:
> In my plsql:
> rai=# select oid, * from pg_class where relfilenode = 5214489;

I was looking for:

select oid, * from pg_class where oid = 5214493;

>
> Result:
> oid | relname | relnamespace | reltype | reloftype | relowner
> | relam | relfilenode | reltablespace | relpages | reltuples |
> relallvisible | reltoastrelid | reltoastidxid | relhasindex |
> relisshared | relpersistence | relkind | relnatts | relchecks |
> relhasoids | relhaspkey | relhasrules | relhastriggers | relhassubclass
> | relispopulated | relfrozenxid | relminmxid | relacl | reloptions
> ---------+-------------+--------------+---------+-----------+----------+-------+-------------+---------------+----------+--------------+---------------+---------------+---------------+-------------+-------------+----------------+---------+----------+-----------+------------+------------+-------------+----------------+----------------+----------------+--------------+------------+--------+------------
> 5214489 | repositorio | 5205962 | 5214491 | 0 | 10
> | 0 | 5214489 | 5205910 | 79303 | 1.31566e+006 |
> 79303 | 5214493 | 0 | t | f | p
> | r | 7 | 0 | f | t
> | f | f | f | t |
> 9360288 | 1 | |
> (1 registro)
>
> Ok?

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com