BUG #16011: Select * query for sequences does not show all columns in output.

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #16011: Select * query for sequences does not show all columns in output.
Дата
Msg-id 16011-caedeeb0f1fc79b7@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #16011: Select * query for sequences does not show allcolumns in output.
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      16011
Logged by:          Pallavi Pathak
Email address:      pallavi.pathak@outlook.com
PostgreSQL version: 11.5
Operating system:   Windows
Description:

0


I am upgrading postgres from 9.1 to 11.5 .

but select query on sequences is returning different output in 11.5 as
compared to 9.1, not all columns are shown in the output.

Output in 11.5

SELECT * FROM session_SEQ;

11.5 : last_value | log_cnt | is_called ------------+---------+----------- 1
| 0 | f (1 row)

Output in 9.1:

SELECT * FROM session_SEQ;

sequence_name | last_value | start_value | increment_by | max_value |
min_value | cache_value | log_cnt | is_cycled | is_called

---------------+------------+-------------+--------------+-----------+-----------+-------------+---------+-----------+-----------
session_seq | 1 | 1 | 1 | 99999999 | 1 | 1 | 0 | f | f

How can we display all the columns in 11.5? is there any workaround?


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #16010: Unexpected reordering of WHERE clause operations and SELECT list function calls
Следующее
От: Anthony Sotolongo
Дата:
Сообщение: Re: BUG #16011: Select * query for sequences does not show allcolumns in output.