From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | pallavi(dot)pathak(at)outlook(dot)com |
Subject: | BUG #16011: Select * query for sequences does not show all columns in output. |
Date: | 2019-09-17 17:45:02 |
Message-ID: | 16011-caedeeb0f1fc79b7@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 16011
Logged by: Pallavi Pathak
Email address: pallavi(dot)pathak(at)outlook(dot)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?
From | Date | Subject | |
---|---|---|---|
Next Message | Anthony Sotolongo | 2019-09-17 17:57:55 | Re: BUG #16011: Select * query for sequences does not show all columns in output. |
Previous Message | Tom Lane | 2019-09-17 16:24:05 | Re: BUG #16010: Unexpected reordering of WHERE clause operations and SELECT list function calls |