I tried this. I created a sequence, and ran last_value, then nextval,
repeatedly. last_value always returned 20 until nextval returned 21, then
last_value returned 40 and kept returning 40 until nextval returned 41, etc.
On Fri, May 14, 2021 at 9:39 AM Dave Page wrote:
>
>
> On Fri, May 14, 202
On Fri, May 14, 2021 at 3:33 PM Michael Shapiro
wrote:
> How does PgAdmin get the current value of a sequence when showing the
> sequence properties?
>
SELECT last_value FROM ;
(essentially. It gets a few other things as well)
--
Dave Page
Blog: https://pgsnake.blogspot.com
Twitter: @pgsnake
How does PgAdmin get the current value of a sequence when showing the
sequence properties?
Hi
(please keep the list CC'd)
On Fri, May 14, 2021 at 3:00 PM Michael Shapiro
wrote:
> Dave, it is weird. We are running many servers each with different
> versions of Postgres. For some servers, the encrypted password is shown,
> for others it is not.
>
>
> It isn't shown for PostgreSQL 12.5
Hi
On Fri, May 14, 2021 at 2:21 PM Michael Shapiro
wrote:
> PgAdmin4 does not show the encrypted password for roles. This was fixed in
>
> https://redmine.postgresql.org/issues/1974
>
> but it is missing now.
>
It's there for me, with both PostgreSQL 11 (RHEL) and 13 (macOS), and
pgAdmin 5.1 an
PgAdmin4 does not show the encrypted password for roles. This was fixed in
https://redmine.postgresql.org/issues/1974
but it is missing now.
Akshay,
The problem seems to be fixed with this new version. Thanks!
Michael
On Fri, May 14, 2021 at 1:08 AM Akshay Joshi
wrote:
> Hi Michael and Richard
>
> We have fixed issue #6420, can you please verify it on the nightly build
> https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/202