The following bug has been logged online: Bug reference: 1830 Logged by: Bernard Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Linux RedHat 9 Description: Non-super-user must be able to copy from a file Details:
On the attempt to bulk load a table from a file that is owned by the non-superuser current database user, the following error message is printed: "must be superuser to COPY to or from a file" What is the reason for this limitation? It can't justifiably be for security reasons because if a web application such as tomcat requires to bulk load tables automatically on a regular basis then one would be forced to let the web application connect as superuser, which is very bad for security. In MySQL bulk loading works for all users. We need a Postgresql solution. We have a web application where both MySQL and Postresql are supported. With Postgresql, the application would have to connect as user postgres. We have to explain this security risk to our clients very clearly. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
