| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Howard Cole <howardnews(at)selestial(dot)com> |
| Cc: | Giuseppe Sacco <giuseppe(at)eppesuigoccas(dot)homedns(dot)org>, PostgreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: About permissions on large objects |
| Date: | 2011-07-13 22:39:07 |
| Message-ID: | 1310596748.3546.5.camel@laptop |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 2011-07-13 at 23:30 +0100, Howard Cole wrote:
> On 13/07/2011 8:15 PM, Giuseppe Sacco wrote:
> >
> > Is there any other possibility?
>
> Hi Guiseppe,
>
> Perhaps you can create a trigger that monitors for the insertion of an
> oid and then grant permissions. No idea if this can be done, but if it
> can it will save you lots of repeated grants.
>
Large Objects are inserted in a system table. And you cannot add
triggers to system tables. So this can't work.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tony Wang | 2011-07-14 01:55:43 | Re: Weird problem that enormous locks |
| Previous Message | Howard Cole | 2011-07-13 22:30:41 | Re: About permissions on large objects |