From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | LENGYEL Zoltan <warnew(at)warnew(dot)nomaam(dot)hu> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pgpsql help |
Date: | 2005-01-17 05:02:16 |
Message-ID: | 20050117050216.GA91823@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Jan 17, 2005 at 05:46:20AM +0100, LENGYEL Zoltan wrote:
> uri alias for $3;
...
> insert into uri (articleid,uri,uritype) values (article_id,uri,urit_id);
PostgreSQL 8.0 will give more context for the error, making it
easier to spot the problem:
ERROR: syntax error at or near "$1" at character 14
QUERY: insert into $1 (articleid, $2 ,uritype) values ( $3 , $4 , $5 )
CONTEXT: PL/pgSQL function "new_uri" line 20 at SQL statement
LINE 1: insert into $1 (articleid, $2 ,uritype) values ( $3 , $4 ,...
The variable "uri" is apparently also the name of a table and a
column in that table. Use a different name for the variable.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
From | Date | Subject | |
---|---|---|---|
Next Message | Mike G. | 2005-01-17 05:08:16 | Re: pgpsql help |
Previous Message | LENGYEL Zoltan | 2005-01-17 04:46:20 | pgpsql help |