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

Re: [GENERAL] BUG #1830: Non-super-user must be able to copy from a

From: Bernard <bht(at)actrix(dot)gen(dot)nz>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-bugs(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] BUG #1830: Non-super-user must be able to copy from a
Date: 2005-08-19 07:21:15
Message-ID: 2k1bg11rgb8ak6k9rmshi64g7tse1tcp99@4ax.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-general
Greg,

The desired COPY FILE functionality for a local non-superuser user
would require a local file. That file is available locally.

A suggested workaround COPY with STDIN would involve the TCP pipe.
This does of course have the support for remote uploads.

But I am not currently interested in remote data transfers.

Regards

Bernard

On 19 Aug 2005 02:03:54 -0400, you wrote:

>
>Oliver Jowett <oliver(at)opencloud(dot)com> writes:
>
>> Bernard was also objecting to the overhead of pushing the data down a
>> TCP pipe when it's already available locally, I think.. I didn't find
>> any real difference there when I compared the two methods, though.
>
>What makes you think it's necessarily available locally?


In response to

Responses

pgsql-bugs by date

Next:From: Sean UttDate: 2005-08-19 07:46:29
Subject: Re: BUG #1830: Non-super-user must be able to copy from a file
Previous:From: QayedDate: 2005-08-19 07:07:51
Subject: BUG #1835: pg_trigger_tgrelid_tgname_index

pgsql-general by date

Next:From: Bill MoseleyDate: 2005-08-19 07:27:40
Subject: Input timestamp from epoch?
Previous:From: Greg StarkDate: 2005-08-19 06:03:54
Subject: Re: [GENERAL] BUG #1830: Non-super-user must be able to copy from a

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