On 2012-06-28 13:51, Stefan de Konink wrote:
On Thu, 28 Jun 2012, 万萌 wrote:
sql>COPY INTO test from ('/home/svom/log3');COPY INTO: insufficient privileges: binary COPY INTO requires administrator rights
the file "log3" is in mode 777, so i dont know why this happend, thanks for help!
The problem is that MonetDB was sured so only the 'superuser' on the database has access to the local filesystem.
Nonsense. The problem is the parentheses. By using parentheses you indicate that the file is a binary file with the data in exactly the right format for MonetDB to use the data without needing to do any parsing. This is only allowed for the database administrator. If your file is actually a CSV file, use the COPY INTO without using parentheses. -- Sjoerd Mullender