From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
---|---|
To: | "'Nguyen Hoai Nam *EXTERN*'" <namptit307(at)gmail(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: The problem is related to concurrent resquests |
Date: | 2016-07-08 09:33:01 |
Message-ID: | A737B7A37273E048B164557ADEF4A58B5386ACD9@ntex2010i.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Nguyen Hoai Nam wrote:
> 2016-05-24 17:31 GMT+07:00 Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)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?
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Nguyen Hoai Nam | 2016-07-11 02:41:58 | Re: The problem is related to concurrent resquests |
Previous Message | Nguyen Hoai Nam | 2016-07-07 07:50:21 | Re: The problem is related to concurrent resquests |