Message-ID: <3E634B76.60308@klaster.net>
Date: Mon, 03 Mar 2003 13:32:54 +0100
From: Tomasz Myrta <jasiek@klaster.net>
User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; PL; rv:1.1) Gecko/20020826
MIME-Version: 1.0
To: Tambet Matiisen <t.matiisen@aprote.ee>
Cc: pgsql-sql@postgresql.org
Subject: Re: pl/pgsql errors
References: <3E633D63.7050406@klaster.net>
	<000701c2e17a$71ebbe50$0e01a8c0@aprote.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

> Probably some_field was declared as alias for $1. I think plpgsql does
> simple find&replace for aliases, that's how $1 appeared in wrong place. I
> usually prefix all procedure parameters with p_, this guards me against this
> situation and also makes code more clear.
> 
>   Tambet
No, no no
I always get this error where table column name equals to declared field 
name. I've just made a special test to check if it has something to 
aliases. Function below doesn't use any arguments nor aliases:

create or replace function test() returns integer as'
declare
  id_miasta integer;
begin
  insert into miasta(id_miasta,nazwa) values (id_miasta,null);
  return 1;
end;
' language 'plpgsql';

Error message is the same. I know this error very well, I know how to 
avoid it, but I'm just asking if it is difficult to change strange error 
message.

Regards,
Tomasz Myrta