From: | Nguyen Hoai Nam <namptit307(at)gmail(dot)com> |
---|---|
To: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
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-11 02:41:58 |
Message-ID: | CA+vg4mNx5Cf5Bukhcuq2E9xbvhe8GUzN8-voj1hyRHm-RgYZQA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi Laurenz Albe, thanks for your reply.
2016-07-08 16:33 GMT+07:00 Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>:
> 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?
>
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Brunnengräber | 2016-07-13 15:58:50 | pg cluster not cleaning up after failover |
Previous Message | Albe Laurenz | 2016-07-08 09:33:01 | Re: The problem is related to concurrent resquests |