Re: About "ERROR: must be *superuser* to COPY to or from a file"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, "John D(dot) Burger" <john(at)mitre(dot)org>, Postgresql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: About "ERROR: must be *superuser* to COPY to or from a file"
Date: 2005-08-31 03:25:36
Message-ID: 27108.1125458736@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greg Stark <gsstark(at)mit(dot)edu> writes:
> Alternatively and actually even better and more secure would be
> passing the fd directly from the client to the server over the socket.

Sure ... on the platforms that support that, for the connection types
for which they support it. But I think that in the long run we'd regret
inventing any SQL operations whose semantics depend on the transport
mechanism.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2005-08-31 03:39:45 Re: Planner create a slow plan without an available index
Previous Message Gavin M. Roy 2005-08-31 03:21:40 Re: Php abstraction layers