On Tue, May 2, 2017 at 6:12 PM, Mahi Gurram <teckym...@gmail.com> wrote: > I'm building some custom extension on top of postgres 9.6.1. As part of > that, I would like to read Heap Tuple directly from my extension using > Primary Key. > > By default, postgres table index(B-Tree) its PrimaryKey(PK). So, i would > like to get TID by doing a lookup into PK's B-Tree index. Using which i > could read HeapTuple directly. > > Please suggest me the easiest way to lookup into PK's B-Tree index for > getting TIDs.
Why don't you just use SPI within your extension? No need to copy the logic for btree lookups this way. https://www.postgresql.org/docs/9.6/static/spi.html > Suggesting a postgres extensions which does B-Tree lookup will also helps > me. contrib/amcheck looks at raw btree data, though I am not sure that you actually need to go down to that. But that's hard to reach a conclusion without more details. -- Michael -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers