On 09/19/2013 08:26 AM, Dave Cramer wrote:
The errors are extra lines after .... with a query like this 2013-09-12 10:33:19.145 WST,"user","dbname",14581,"192.168.1.22:58840 <http://192.168.1.22:58840>",523126d3.38f5,1,"SELECT",2013-09-12 10:28:35 WST,6/503023,0,ERROR,42P01,"relation ""dds_stores"" does not exist",,,,,,"WITH RECURSIVE recursive_stores(id, name) AS (
I going to assume you mean after the ,,,,,, and are referring to the WITH query.
Several questions: 1) Are you using the example table from the docs?: http://www.postgresql.org/docs/9.3/interactive/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-CSVLOG If not what is the table definition? 2) What is the actual error message you get when running COPY? -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
