Re: [GENERAL] Stored Procedure: Copy table from; path = text variable

2007-07-04 Thread Dave Page
Richard Huxton wrote: > Dave Page wrote: >> Richard Huxton wrote: >>> Charles Pare wrote: Wow, it works great Thank's for the quick answer >>> 12 minutes? I've seen bug-patches turned around quicker than that by Tom >>> ;-) >> >> Yeah, that's really quite disappointing Richard - you need

Re: [GENERAL] Stored Procedure: Copy table from; path = text variable

2007-07-03 Thread Richard Huxton
Dave Page wrote: Richard Huxton wrote: Charles Pare wrote: Wow, it works great Thank's for the quick answer 12 minutes? I've seen bug-patches turned around quicker than that by Tom ;-) Yeah, that's really quite disappointing Richard - you need to pull your socks up :-) Would have been und

Re: [GENERAL] Stored Procedure: Copy table from; path = text variable

2007-07-03 Thread Dave Page
Richard Huxton wrote: > Charles Pare wrote: >> Wow, it works great >> Thank's for the quick answer > > 12 minutes? I've seen bug-patches turned around quicker than that by Tom > ;-) Yeah, that's really quite disappointing Richard - you need to pull your socks up :-) /D

Re: [GENERAL] Stored Procedure: Copy table from; path = text variable

2007-07-03 Thread Richard Huxton
Charles Pare wrote: Wow, it works great > Thank's for the quick answer 12 minutes? I've seen bug-patches turned around quicker than that by Tom ;-) > The Postgres community is amazing! Mostly by volunteers helping out on lists :-) There's always someone out there you can lend a helping han

Re: [GENERAL] Stored Procedure: Copy table from; path = text variable

2007-07-03 Thread Charles Pare
Wow, it works greatThank's for the quick answerThe Postgres community is amazing!Charles> Date: Tue, 3 Jul 2007 20:01:03 +0100> From: [EMAIL PROTECTED]> To: [EMAIL PROTECTED]> CC: pgsql-general@postgresql.org> Subject: Re: [GENERAL] Stored Procedure: Copy table from;

Re: [GENERAL] Stored Procedure: Copy table from; path = text variable

2007-07-03 Thread Richard Huxton
Charles Pare wrote: Hi, in a stored procedure, if I do COPY table FROM 'mypath' DELIMITERS '\t'; it works but if my path is a text variable which contain my path, i.e.COPY table FROM mytextvar DELIMITERS '\t'; it doesn't work, I get ERROR: syntax error at or near "$1"SQL state: 42601Context: SQL

[GENERAL] Stored Procedure: Copy table from; path = text variable

2007-07-03 Thread Charles Pare
Hi, in a stored procedure, if I do COPY table FROM 'mypath' DELIMITERS '\t'; it works but if my path is a text variable which contain my path, i.e.COPY table FROM mytextvar DELIMITERS '\t'; it doesn't work, I get ERROR: syntax error at or near "$1"SQL state: 42601Context: SQL statement in PL/PgS