Bug - SQL can not be generated for Login Roles

Поиск
Список
Период
Сортировка
От Rossiter, Russell D.
Тема Bug - SQL can not be generated for Login Roles
Дата
Msg-id 12369a02d52d453b91a9c26d6f30d9a4@SSC-DAG3-01.ba.ad.ssa.gov
обсуждение исходный текст
Список pgsql-bugs

To Whom it may concern,

 

BUG REQUEST:

 

I am trying to generate the DDL of a login role by clicking on the login role in the pgAdmin tool.   In pgAdmin 3 it works and generates the DDL,  but in pgAdmin 4 It just hangs and you get Connection to the server has been lost.  I have a high number of Login/Group Roles (over 700+ login roles) and I would like to  get the DDL for any login user I select.   I think the query behind the scenes cannot handle the volume of login roles, and it’s similar to a Cartesian product with the query it uses.

 

 

 

 

 

ENHANCEMENT REQUEST

Also, if possible I would like the following enhancements to this pgAdmin 4 Tool.   I would like to have a compare tool incorporated into this utility.  I would like to be able to compare databases/schemas between other databases/schemas and for it to generate a fixit script that would have all the sql to make either the source / target the same.  (like a diff)

 

 

 

 

Russell D. Rossiter

DCS/OSE/OSA/DDBS/DBAB

Telework Day - Monday & Tuesday

410-966-0069 -  Office

609-221-2376  -  iPhone & ADS number

Email: russell.d.rossiter@ssa.gov

IM: Skype for Business

 

SSA Logo

 

Notice of Confidentiality:

 

This electronic mail transmission is privileged and confidential and is intended only for the review of the party to whom it is addressed.  Any unauthorized disclosure, reproduction, distribution or taking of action in reliance on the contents of the information is prohibited.  If you have received this message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it.  Unintended transmission shall not constitute waiver of any privilege.

 

 

Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15674: Errors
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15675: upper_inf() always returns false for non-null daterange, tstzrange values