Re: Print b-tree tuples

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Print b-tree tuples
Дата
Msg-id 24713.1357331162@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Print b-tree tuples  (Samuel Vogel <s@muel-vogel.de>)
Ответы Re: Print b-tree tuples  (Samuel Vogel <s@muel-vogel.de>)
Список 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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: dynamic SQL - possible performance regression in 9.2
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: dynamic SQL - possible performance regression in 9.2