From: | Anthony Sotolongo <asotolongo(at)gmail(dot)com> |
---|---|
To: | pallavi(dot)pathak(at)outlook(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org, PG Bug reporting form <noreply(at)postgresql(dot)org> |
Subject: | Re: BUG #16011: Select * query for sequences does not show all columns in output. |
Date: | 2019-09-17 17:57:55 |
Message-ID: | e1e9ca36-7ae0-a33c-f8e4-c8fbdc00f78b@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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(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 | Kiran Khatke | 2019-09-17 19:21:22 | Re: BUG #16007: Regarding patch for BUG #3995: pqSocketCheck doesn't return |
Previous Message | PG Bug reporting form | 2019-09-17 17:45:02 | BUG #16011: Select * query for sequences does not show all columns in output. |