Re: Print b-tree tuples
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Samuel Vogel <s@muel-vogel.de>
Cc: pgsql-hackers@postgresql.org
Date: 2013-01-04T20:26:02Z
Lists: pgsql-hackers
Samuel Vogel <s@muel-vogel.de> writes: > I'm trying to print out the tuples in the b-tree nodes for analysis, but > when iterate over more than the first entry of the tuples (scanKey++), I > strangely get the error below on query execution: > ERROR: relation "simpletest" does not exist > LINE 1: SELECT * FROM simpletest WHERE id = 50; Is this patch the only thing you changed? The only obvious explanation for the above error (other than "you fat-fingered the query") seems to be that you caused index searches in pg_class to fail, but I don't see how this patch could be affecting the result of _bt_binsrch. regards, tom lane