Ok thanks for now. I understood the problem and what I
should do to fix it. Will try that later.
Thanks for all the tips and the REALLY FAST answers!!
--- John DeSoi <[EMAIL PROTECTED]> wrote:
>
> On Mar 27, 2006, at 2:10 PM, Dino Vliet wrote:
>
> > Can somebody tell me why my location variab
On Mar 27, 2006, at 2:10 PM, Dino Vliet wrote:
Can somebody tell me why my location variable is NOT
working as expected? I would like to use it in a loop
to create multiple text files which names would be
different because of the way I concatenate it with the
looping variable.
You can't just
Dino Vliet <[EMAIL PROTECTED]> writes:
> I trying for days to get this simple plpgsql procedure
> to run but I keep getting this error:
You can't ordinarily use a variable to supply a table (or field) name
in a plpgsql query; that doesn't work because plpgsql wants to cache a
plan for the query.
Dino Vliet wrote:
Nope:-(
I added it just now and still the same error message!!
Have you tried it with your "copy" command executed dynamically?
eg. execute 'copy cancel to location ...';
---(end of broadcast)---
TIP 1: if posting/reading throu
Nope:-(
I added it just now and still the same error message!!
--- Bricklen Anderson <[EMAIL PROTECTED]> wrote:
> Dino Vliet wrote:
> > Hi guys,
> >
> > I trying for days to get this simple plpgsql
> procedure
> > to run but I keep getting this error:
> >
> > psql:pgsql_procedure.txt:15: ERR
Dino Vliet wrote:
Hi guys,
I trying for days to get this simple plpgsql procedure
to run but I keep getting this error:
psql:pgsql_procedure.txt:15: ERROR: syntax error at
or near at character 17
QUERY: copy cancel TO $1 with delimiter as ',' null
as '.'
CONTEXT: SQL statement in PL/PgSQL f
Hi guys,
I trying for days to get this simple plpgsql procedure
to run but I keep getting this error:
psql:pgsql_procedure.txt:15: ERROR: syntax error at
or near at character 17
QUERY: copy cancel TO $1 with delimiter as ',' null
as '.'
CONTEXT: SQL statement in PL/PgSQL function doedit
near
