Re: Xlogdump compiling error : undefined reference to `ber_sockbuf_io_udp' - Mailing list pgsql-general

Adarsh Sharma escribió:

> [cur:1835/26FAFEF8, xid:471303469, rmid:11(Btree), len/tot_len:18/5754, info:8, prev:1835/26FAFEB0] insert_leaf:
s/d/r:1663/1228184/1363155tid 28366/20 

> Is dere any document where i can co-relate this tid with relations/indexes
> in the database. I tried but not able to find :-
>
> wap_prod_adserve=# SELECT relname, oid FROM pg_class where oid=1363155 ;
>  relname | oid
> ---------+-----
> (0 rows)

Probably the reason you don't find any rows is because you're querying
the wrong column.  The "r" stands for relfilenode, and thus you must use
relfilenode in the WHERE clause, not oid:

SELECT relname, oid FROM pg_class where relfilenode=1363155 ;

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services