Re: sequence current value

2021-05-14 Thread Michael Shapiro
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,

Re: sequence current value

2021-05-14 Thread Dave Page
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

sequence current value

2021-05-14 Thread Michael Shapiro
How does PgAdmin get the current value of a sequence when showing the sequence properties?

Re: encrypted password for roles not shown

2021-05-14 Thread Dave Page
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

Re: encrypted password for roles not shown

2021-05-14 Thread Dave Page
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

encrypted password for roles not shown

2021-05-14 Thread Michael Shapiro
PgAdmin4 does not show the encrypted password for roles. This was fixed in https://redmine.postgresql.org/issues/1974 but it is missing now.

Re: PgAdmin doesn't quit on Mac

2021-05-14 Thread Michael Shapiro
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 >

Re: PgAdmin doesn't quit on Mac

2021-05-14 Thread Akshay Joshi
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/2021-05-14/ On Fri, May 14, 2021 at 1:01 AM Richard Brockie wrote: > I've seen this too. Sometimes after force-quitting pgadmin a process >