Re: Permissions for large-object comments

From: Shane Wegner <shane(at)cm(dot)nu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Permissions for large-object comments
Date: 2001-08-24 03:00:30
Message-ID: 20010823200030.A17907@cm.nu
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Thu, Aug 23, 2001 at 10:57:29PM -0400, Tom Lane wrote:
> Shane Wegner <shane(at)cm(dot)nu> writes:
> > test=> \lo_unlink 89803
> > ERROR: pg_description: Permission denied.
>
> Hmm. Maybe those client-side comment manipulations in psql aren't
> such a hot idea. I know I never tested them as non-superuser :-(
>
> Shane, try that from a superuser Postgres userid. Meanwhile,
> it's back to the drawing board for us.

Yes an unlink works fine as the superuser. I can't unlink
using the DBI interface either though which suggests it not
being psql's fault.

Shane

>
> regards, tom lane

--
Shane Wegner: shane(at)cm(dot)nu
http://www.cm.nu/~shane/
PGP: 1024D/FFE3035D
A0ED DAC4 77EC D674 5487
5B5C 4F89 9A4E FFE3 035D

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-08-24 03:31:14 Re: Backend message type 0x44 arrived while idle
Previous Message Tom Lane 2001-08-24 02:57:29 Permissions for large-object comments

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-08-24 03:12:26 Re: A couple items on TODO
Previous Message Tom Lane 2001-08-24 02:57:29 Permissions for large-object comments