Re: Print b-tree tuples

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Samuel Vogel <s(at)muel-vogel(dot)de>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Print b-tree tuples
Date: 2013-01-04 20:26:02
Message-ID: 24713.1357331162@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Samuel Vogel <s(at)muel-vogel(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2013-01-04 20:26:12 Re: dynamic SQL - possible performance regression in 9.2
Previous Message Andrew Dunstan 2013-01-04 20:23:58 Re: json api WIP patch