RE: Can not ALTER TEXT SEARCH DICTIONARY intdict which is default in dict_int

Got it! Thank you all very much!   - Original message -From: "David G. Johnston" To: "Tom Lane" Cc: "Li EF Zhang" , "Laurenz Albe" , "pgsql-generallists.postgresql.org" Subject: [EXTERNAL] Re: Can not ALTER TEXT SEARCH DICTIONARY intdict w

RE: Can not ALTER TEXT SEARCH DICTIONARY intdict which is default in dict_int

Thanks for your answer. My doubt is that since an ordinary user creates the extension, shouldn't be this user the owner of the objects created within the extension?   - Original message -From: "Laurenz Albe" To: "Li EF Zhang" , pgsql-general@lists.postgresql.org

Can not ALTER TEXT SEARCH DICTIONARY intdict which is default in dict_int

Hi,   dict_int is trusted extension in pg13. After creating dict_int extension with unprivileged user, ALTER TEXT SEARCH DICTIONARY intdict ((MAXLEN = 7) failed.   admin=> ALTER TEXT SEARCH DICTIONARY intdict (MAXLEN = 7);ERROR:  must be owner of text search dictionary intdict   This is by design o

Make bloom extension trusted, but can not drop with normal user

Hi all,   Since pg13 support trusted extension, so I changed control file of bloom and make it trusted. The test provided by pg13 for bloom passed using normal user. But when i tried to drop extension, it failed.   test=> create extension bloom;CREATE EXTENSIONtest=> drop extension bloom;ERROR:  mu

RE: SQL to query running transactions with subtransactions that exceeds 64

WHERE (now() - pg_stat_activity.query_start) > interval '5 minutes'; Thanks, Lily - Original message -From: Laurenz Albe To: Li EF Zhang , pgsql-general@lists.postgresql.orgCc:Subject: [EXTERNAL] Re: SQL to query running transactions with subtransactions that exceeds 64Date: Wed, Jan 6, 2021 12:49 PM  On T

SQL to query running transactions with subtransactions that exceeds 64

I am new to postgresql and sql. I want to check running transactions whose subtransactions exceeds 64. Is there any SQL statement or other method can do this? Thanks!