I am now using PgAdmin 8.2 on Mac. The left panel no longer lists any
servers nor does PgAdmin ask for the master password when it starts. It is
asking to use my keychain (I don't have that setup or even know what it is).
i, 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
&g
How does PgAdmin get the current value of a sequence when showing the
sequence properties?
PgAdmin4 does not show the encrypted password for roles. This was fixed in
https://redmine.postgresql.org/issues/1974
but it is missing now.
th first shutting down the underlying
>> database server before quitting pyAdmin, but I haven't made an exhaustive
>> investigation.
>>
>> On Thu, May 13, 2021 at 11:24 AM Michael Shapiro
>> wrote:
>>
>>> Sometimes when I "quit" PgAdmin on M
Sometimes when I "quit" PgAdmin on Mac OS Big Sur (11.3.1), the GUI goes
away but PgAdmin continues to run. Even when I ask it to quit it still runs
and I have to use Force Quit to stop it.
I am running version 5.2 (4280.88) of PgAdmin.
Any word on this issue?
https://redmine.postgresql.org/issues/5404
Don't know if this is useful or not, but I found this:
https://ugetfix.com/ask/how-to-fix-application-unable-to-start-error-0x07b/
On Sun, Jun 7, 2020 at 10:37 PM Aditya Toshniwal <
aditya.toshni...@enterprisedb.com> wrote:
> Hi Sibongile,
>
> Could you please share more details like screen
Any progress on this issue?
On Thu, Apr 2, 2020 at 6:21 AM Michael Shapiro wrote:
> What is the status of https://redmine.postgresql.org/issues/2519?
>>
>
Can the login roles that are members of a group role be shown when
examining a group role?
For a given login role, PgAdmin will show me which group roles it is a
member of, but PgAdmin won't show me the logins that are members of a
specific group.
If I create a server that uses ssh tunneling, I have to ask PgAdmin to
disconnect twice before it disconnects. Servers that do not use ssh
tunneling will disconnect upon the first request to disconnect.
>
> What is the status of https://redmine.postgresql.org/issues/2519?
>
How can I see the encrypted password for a login role?
How does PgAdmin extract the sql for a view?
If I run
select definition from pg_catalog.pg_views where viewname = 'xxx' and
schemaname='yyy'
the tables in the FROM clauses may or may not be fully qualified, depending
on the current search_path. If the search_path includes the schema for a
tabl
When I look at the DDL for an object (eg view or function) under the SQL
tab in PgAdmin4, how do I save it to a file?
Also, is there a way to run the DDL in a different database (so I can
"copy" the object from one database to another)
What is the status of https://redmine.postgresql.org/issues/2519?
The feature that was in PgAdmin3 of the browser being able to show the
trigger function from the table was really useful. Will that be added back
to PgAdmin4?
Thanks! That fixed it
On Fri, Sep 20, 2019 at 9:31 PM Murtuza Zabuawala <
murtuza.zabuaw...@enterprisedb.com> wrote:
> Hello,
>
> On Fri, 20 Sep 2019, 20:41 Michael Shapiro, wrote:
>
>> It looks as if the display of function code in PgAdmin4 is not handling
>> inde
It looks as if the display of function code in PgAdmin4 is not handling
indentation properly, possibly due to TABS in the SQL.
Code that looks like
if .
then
if
then
...
end if;
end if;
gets displayed as
if ...
then
if ...
then
... <<-- this line is not i
19 at 10:46 AM Michael Shapiro
> wrote:
>
>> Great! I looked for an issue about it on redmine.postgres.org. I didn't
>> see one so I created https://redmine.postgresql.org/issues/4732.
>>
>>
>> On Wed, Sep 11, 2019 at 10:36 PM Akshay Joshi <
>> aksh
ll be
> schedule on 19th September.
>
> On Thu, 12 Sep, 2019, 01:40 Michael Shapiro, wrote:
>
>> When is this error when getting an object's SQL going to be fixed?
>>
>> can only concatenate str (not "NoneType") to str
>>
>
When is this error when getting an object's SQL going to be fixed?
can only concatenate str (not "NoneType") to str
I'm not sure if the schema the extension is installed in is causing the
problem. I always install extensions in the pg_catalog schema.
On Tue, Aug 6, 2019 at 7:32 AM Ashesh Vashi
wrote:
> If you're running from the sql editor, then - you have either of the two
> options:
> Set search_path = 'tel
;Save" button will track changes and only save if there are any changes.
>
> On Thu, Jul 18, 2019, 11:42 Michael Shapiro wrote:
>
>> Dave,
>>
>> I'd like to make a feature request that PgAdmin4 add a save button (that
>> is always enabled) to any window that
e SQL window.
On Thu, Jul 18, 2019 at 9:22 AM Dave Page wrote:
>
>
> On Thu, Jul 18, 2019 at 3:09 PM Ray O'Donnell wrote:
>
>> On 18/07/2019 14:43, Michael Shapiro wrote:
>> > Then what?
>> >
>> > On Thu, Jul 18, 2019 at 8:31 AM Ray O'Donnel
After selecting an object (eg a view) how do I save the SQL that PgAdmin4
extracts from the server? I don't see a "SAVE" button.
>
PgAdmin3 had the ability to change the connection for an SQL window.
Does PgAdmin4 have that feature?
On Tue, Jun 4, 2019 at 8:40 AM Isaías Sánchez
wrote:
> Just: select * from pg_authid;
>
> En 4 de junio de 2019 15:14:49 Michael Shapiro
> escribió:
>
>> PgAdmin3 has the ability to see the encrypted password for a login role.
>> That allow me to copy the login role
PgAdmin3 has the ability to see the encrypted password for a login role.
That allow me to copy the login role password from one server to another
(without having to know the password).
I don't see how to see the encrypted password for a login role in PgAdmin4
I'd like to know how people do this as well. I have been creating new
Servers for each account.
On Sat, May 18, 2019 at 5:16 PM Michel Feinstein
wrote:
> Hi guys, I am looking for opinions on how you use pgAdmin for dealing with
> several accounts.
>
> For example, I have an "admin" account with
Mon, May 13, 2019 at 4:58 AM Khushboo Vashi <
khushboo.va...@enterprisedb.com> wrote:
>
>
> On Mon, May 13, 2019 at 3:06 PM Michael Shapiro
> wrote:
>
>> I ran this in one of my databases
>>
>> ALTER DEFAULT PRIVILEGES FOR ROLE some_role REVOKE EXECUTE O
>
> On Sun, May 12, 2019 at 7:42 PM Michael Shapiro
> wrote:
>
>> Where in PgAdmin4 can I see (and set) default privileges for a role?
>>
> Please refer
> https://www.pgadmin.org/docs/pgadmin4/4.x/role_dialog.html?highlight=Privileges
>
>
Where in PgAdmin4 can I see (and set) default privileges for a role?
Will it ever be possible to:
(1) run more than one query is a single query editor window and see the
results of each query (as opposed to only the results from the last query)?
(2) edit the results to change the underlying table (assuming the query is
against a single table)?
pgadmin3 has the feature that when you selected a table trigger in the
object browser panel, it would connect the trigger to the trigger function
and allow you to see the function directly from the trigger. That seems to
be missing in pgadmin4. Now, in order to view the function, you have to go
to
34 matches
Mail list logo
