Re: Permissions for large-object comments - Mailing list pgsql-general

From Shane Wegner
Subject Re: Permissions for large-object comments
Date
Msg-id 20010823200030.A17907@cm.nu
Whole thread Raw
In response to Problems with large objects  (Shane Wegner <shane@cm.nu>)
List pgsql-general
On Thu, Aug 23, 2001 at 10:57:29PM -0400, Tom Lane wrote:
> Shane Wegner <shane@cm.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@cm.nu
              http://www.cm.nu/~shane/
PGP:          1024D/FFE3035D
              A0ED DAC4 77EC D674 5487
              5B5C 4F89 9A4E FFE3 035D

pgsql-general by date:

Previous
From: "Tsukaeru.net Webmaster"
Date:
Subject: Re: Backend message type 0x44 arrived while idle
Next
From: Tom Lane
Date:
Subject: Re: Backend message type 0x44 arrived while idle