Re: Issues Restoring

2023-01-05 Thread Aditya Toshniwal
Hi Tiffany, Please share the exact steps you're following. What is the error you're getting on restore? On Wed, Jan 4, 2023 at 3:10 PM Tiffany wrote: > Good afternoon, I am taking a SQL course with Udemy and when I try to > restore the pgadmin app, it doesn't appear. I have uninstalled/reinstal

Re: Issues Restoring

2023-01-05 Thread Ray O'Donnell
On 04/01/2023 13:53, Tiffany wrote: Hello, I’m on Windows. I installed pgadmin through Chrome, I hope that answers your question. When I try to restore, I don’t even see the pgadmin app available on my end and it keeps just re-installing. I only have the pgadmin exe available, not the pgadmin a

RE: pgAdmin error with new PG15 servers: argument of type 'Response' is not iterable

2023-01-05 Thread Stephen Todd Morrow
Sure thing Yogesh. This is extracted from a schema-only dump of schema p_atlas_mn: CREATE SCHEMA p_atlas_mn; ALTER SCHEMA p_atlas_mn OWNER TO p_atlas_mn; GRANT USAGE ON SCHEMA p_atlas_mn TO select_any_table_role; GRANT USAGE ON SCHEMA p_atlas_mn TO ro_any_table; ALTER DEFAULT PRIVILEGES FOR ROLE

Icons are missing in PGadmin 4

2023-01-05 Thread Berg, Erwin van den
Hi, We have installed PGAdmin 4 on another server and copied pgadmin4.db as an export - import methode to create the existing connections. When we start PGadmin all the icons are missing, at the original location they are still there. Do you have an idea what went wrong? [cid:image001.png@01D9

Re: pgAdmin error with new PG15 servers: argument of type 'Response' is not iterable

2023-01-05 Thread Yogesh Mahajan
Hi Steve, Could you please provide DDL for schema & database? I could not reproduce the issue. Here is my schema DDL - CREATE SCHEMA IF NOT EXISTS test123 AUTHORIZATION postgres; GRANT CREATE ON SCHEMA test123 TO postgres; GRANT USAGE ON SCHEMA test123 TO postgres WITH GRANT OPTION; GRANT C

RE: pgAdmin error with new PG15 servers: argument of type 'Response' is not iterable

2023-01-05 Thread Stephen Todd Morrow
Hi Yogesh. Should’ve clarified that this is for any & all schemas. Not sure if this image attachment will come through, but if you click on any of the 79 schemas for this database in the browser when the SQL tab is active, you get the error: [cid:image001.png@01D920E5.27F24A10] Ditto if you ri

Re: pgAdmin error with new PG15 servers: argument of type 'Response' is not iterable

2023-01-05 Thread Yogesh Mahajan
Hi, Could you please provide DDL for schema? and Can you please share output for below queries - 1.SELECT defaclobjtype, pg_catalog.aclexplode(defaclacl) as acl FROM pg_catalog.pg_namespace nsp LEFT OUTER JOIN pg_catalog.pg_default_acl dacl ON (dacl.defaclnamespace = nsp.oid) WHERE nsp.oid=::oid