X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 4D546475925 for ; Mon, 3 Mar 2003 06:32:53 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 27244-08 for ; Mon, 3 Mar 2003 06:32:40 -0500 (EST) Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66]) by postgresql.org (Postfix) with ESMTP id 44F2047590C for ; Mon, 3 Mar 2003 06:32:40 -0500 (EST) Received: from klaster.net (pa167.krakow.cvx.ppp.tpnet.pl [213.76.36.167]) by serwer.skawsoft.com.pl (Postfix) with ESMTP id 058F32B880 for ; Mon, 3 Mar 2003 12:31:04 +0100 (CET) Message-ID: <3E633D63.7050406@klaster.net> Date: Mon, 03 Mar 2003 12:32:51 +0100 From: Tomasz Myrta User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; PL; rv:1.1) Gecko/20020826 X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: "'pgsql-sql@postgresql.org'" Subject: pl/pgsql errors Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new X-Archive-Number: 200303/62 X-Sequence-Number: 12102 Hi create function.... declare some_field integer; begin some_field=1; insert into some_table (some_field) values (some_field); end; When we try to execute such function, we get: "ERROR: parser: parse error at or near "$1" at character..." Well, example above is clear enough to find, that I declared field with the same name as in a table. I lost a lot of time trying to find mistake inside long functions until I remembered, what this strange error mean. Would it be difficult to add special ERROR for this case? It annoyed me so many times... Regards, Tomasz Myrta