Re: [pgadmin-support] [SQL] Grants

INSERT ON TABLE base."local" TO administrators; > > Still the same problem. :( Two things I see. The first may only be a translation artifact. You have CREATE ROLE administradores and then GRANT to administrators on the table. Second in the CREATE ROLE ezequias you have NOINHERIT. This means ezequias does not automatically assume the privileges of the ROLES it belongs to. To acquire the privileges you have to do a SET ROLE administrators at the connection. -- Adrian Klaver [EMAIL PROTECTED] ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [pgadmin-support] [GENERAL] need approval to join forums/community

ailing Lists https://www.postgresql.org/list/ or Community account: https://www.postgresql.org/account/signup/ or both or something else? Also, how did you sign up? thanks PhaniKumar -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgadmin-support mailing list (pgadmin-s

Re: [pgadmin-support] [GENERAL] Queries are taking way longer in 9.6 than 9.5

-> Index Scan using tblcnaccounts_pkey on tblcnaccounts a (cost=0.08..0.36 rows=1 width=4) Index Cond: (master_user_id = d.master_user_id) Filter: ((user_name)::text = 'dd'::text) (19 rows) Regards, ravi -- Adrian Klaver adri

Re: [pgadmin-support] [GENERAL] Moving from 9.5 to 9.6

then what are steps required and is it done by any patching or we have to completely upgrade from. 9.5 to 9.6 Complete upgrade. -Pawan -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription

Re: [pgadmin-support] [GENERAL] factor effecting performance of postgres

ggest..! *-Pawan* -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support