user-friendliness improvement of pageinspect

Поиск
Список
Период
Сортировка
От 杨杰
Тема user-friendliness improvement of pageinspect
Дата
Msg-id 52bc017.4d33.1648322feb3.Coremail.yonj1e@163.com
обсуждение исходный текст
Ответы Re: user-friendliness improvement of pageinspect  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-hackers
font{ line-height: 1.6; } ul,ol{ padding-left: 20px; list-style-position: inside; }
Hi,

Why does the heap_page_item () of the pageinspect extension not consider providing better user-friendliness?

My test table has the following data, and when I look at the t_data I see data of type bytea instead of a more intuitive type, even the same type as the original table.

# select * from test1;
 a |  b   
---+------
 1 | text
(1 row)

# SELECT lp as tuple, t_xmin, t_xmax, t_attrs[1] as a, t_attrs[2] as b FROM heap_page_item_attrs(get_raw_page('test1', 0), 'test1');
 tuple | t_xmin | t_xmax |     a      |      b       
-------+--------+--------+------------+--------------
     1 |    587 |      0 | \x01000000 | \x0b74657874
(1 row)

Similar to this effect:

# SELECT lp as tuple, t_xmin, t_xmax, t_attrs[1] as a, t_attrs[2] as b FROM heap_page_item_attrs(get_raw_page('test1', 0), 'test1');
 tuple | t_xmin | t_xmax |     a      |      b       
-------+--------+--------+------------+--------------
     1 |    587 |      0 | 1 | text
(1 row)

Look forward to the solution.
a#ntes-pcmail-signature-default:hover { text-decoration: underline; color: #199cff; cursor: pointer; } a#ntes-pcmail-signature-default:active { text-decoration: underline; color: #246fce; cursor: pointer; }
font{ line-height: 1.6; }
font{ line-height: 1.6; }
font{ line-height: 1.6; }

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Non-reserved replication slots and slot advancing
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Non-reserved replication slots and slot advancing