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

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

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

Tom Lane

2005-08-31, 3:24 am

Greg Stark <gsstark@mit.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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Sponsored Links