Thread

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

   PG Bug reporting form <noreply@postgresql.org> — 2019-09-17T17:45:02Z

   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?
   
   

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

   Anthony Sotolongo <asotolongo@gmail.com> — 2019-09-17T17:57:55Z

   hi, this is not a bug, the catalog change from pg 10 , you can get the 
   rest of columns in pg_sequences catalog view
   
   
   select * from pg_sequences  where sequencename  = 'session_SEQ'
   
     regards
   
   
   On 17-09-19 2:45 p. m., PG Bug reporting form wrote:
   > 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?
   >