Re: The problem is related to concurrent resquests

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

In response to

Responses

Browse pgsql-admin by date

  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