"Karki, Sanjay" writes:
> I need to grant select on privilege in pg_catalog to user so I can connect
> via Toad Data point ,
Why do you think you need to do that? Most catalogs have public
select privilege already, and for the ones that don't, there are
very good reasons why not. I don't know
On Thursday, May 23, 2024, Karki, Sanjay wrote:
>
> I need to grant select on privilege in pg_catalog to user so I can connect
> via Toad Data point ,
>
> Users can already select from the tables in pg_catalog, grant able
privileges not required or allowed. Of course, some specific data is
Hi ,
I need to grant select on privilege in pg_catalog to user so I can connect via
Toad Data point ,
I tried by
grant select on all tables in schema pg_catalog to group sys;
while connecting as sys.
But it throws me error
grant select on all tables in schema pg_catalog to sys ;
ERROR:
Sorry, I forgot to show version of PostgreSQL:
https://www.postgresql.org/message-id/CAAqA9PQXEmG%3Dk3WpDTmHZL-VKcMpDEA3ZC06Qr0ASO3oTA7bdw%40mail.gmail.com
"Invalidation pg catalog cache in trigger functions"
was detected on "PostgreSQL 9.2.18 on x86_64-unknown-linux-gnu, compiled
There is a bug connected with invalidation pg catalog cache in trigger
functions
Another example of this bug I have already reported [1]
The following bug has been logged on the website:
Bug reference: 14879
Logged by: Konstantin Evteev
Email address: konst583(at)gmail(dot)com