| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | Dave Cramer <pg(at)fastcrypt(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: reading cvs logs with pgadmin queries |
| Date: | 2013-09-20 00:25:48 |
| Message-ID: | 523B960C.2050807@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?:
If not what is the table definition?
2) What is the actual error message you get when running COPY?
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2013-09-20 01:04:15 | Re: reading cvs logs with pgadmin queries |
| Previous Message | Michael Nolan | 2013-09-19 20:39:44 | Re: How to failover from Primary to Standby and Set the old Primary as a new Standby |