Skip site navigation (1) Skip section navigation (2)

Re: Permissions for large-object comments

From: Shane Wegner <shane(at)cm(dot)nu>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Permissions for large-object comments
Date: 2001-08-25 00:48:18
Message-ID: 20010824174818.A14087@cm.nu (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-generalpgsql-hackers
On Sat, Aug 25, 2001 at 02:45:40AM +0200, Peter Eisentraut wrote:
> Tom Lane writes:
> 
> > 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.
> 
> I'm not sure about the future of the large objects, so I'm less eager to
> invent a new mechanism.  I'm open to ideas, however.

Well as I'm not a developer, this it out of my league. 
However, if the future of large objects is in question, is
there a better way I should be storing large chunks of
binary data in the database.  The text column doesn't seem
to support it.
Regards,
Shane

-- 
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

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2001-08-25 01:36:57
Subject: MD5 removal of int64 code
Previous:From: Peter EisentrautDate: 2001-08-25 00:45:40
Subject: Re: Permissions for large-object comments

pgsql-general by date

Next:From: Tom LaneDate: 2001-08-25 04:37:09
Subject: Re: backend dies on my aggregate function in 7.1.2
Previous:From: Peter EisentrautDate: 2001-08-25 00:45:40
Subject: Re: Permissions for large-object comments

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group