Re: The problem is related to concurrent resquests - Mailing list pgsql-admin

From Nguyen Hoai Nam
Subject Re: The problem is related to concurrent resquests
Date
Msg-id CA+vg4mNx5Cf5Bukhcuq2E9xbvhe8GUzN8-voj1hyRHm-RgYZQA@mail.gmail.com
Whole thread Raw
In response to Re: The problem is related to concurrent resquests  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-admin
Hi Laurenz Albe, thanks for your reply.

2016-07-08 16:33 GMT+07:00 Albe Laurenz <laurenz.albe@wien.gv.at>:
Nguyen Hoai Nam wrote:
> 2016-05-24 17:31 GMT+07:00 Albe Laurenz <laurenz.albe@wien.gv.at>:
>> This is getting more difficult, but you can *still* do it with an exclusion
>> constraint in PostgreSQL. You need to install an extension with a
>> GiST operator class for varchar:
>>
>> test=# CREATE EXTENSION btree_gist;
>
> At this point, the system require superuser permission. But in my case, an user doesn't have superuser
> permission so they can't create a btree_gist extersion. Do you any idea to solve this? Currently, I am
> trying to use "GIN" but it's not still success. How about "GIN"?

Yes, you need a superuser to install the extension for you.
This has to be done only once, and from then on everybody can
use the feature.

I'm sure there is a superuser who can do that for you, right?

I understood what you mean. But in my case, I am writting code for community so I can't request all admin that creatting PG extersion. I am trying a solution which doesn't use extersion but I don't find it yet. Anyway, thank you for your help. Your solution is very good.

Yours,
Laurenz Albe

Cheers,
Nam

pgsql-admin by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: The problem is related to concurrent resquests
Next
From: Peter Brunnengräber
Date:
Subject: pg cluster not cleaning up after failover