plpgsql bug(?) - Mailing list pgsql-sql

From Kovacs Zoltan
Subject plpgsql bug(?)
Date
Msg-id Pine.LNX.4.05.10001051123380.19358-100000@pc10.radnoti-szeged.sulinet.hu
Whole thread Raw
List pgsql-sql
Dear Jan,

I have started to use plpgsql language for triggers (especially
for 'UPDATE AFTER' ones). It works very good, except the following:

CREATE FUNCTION "partner_t22" ( ) RETURNS opaque AS 
'begin if new.az != old.az then update vev�_megrendel�se 
set vev� = new.az where vev� = old.az; end if; return new; end;'
LANGUAGE 'plpgsql';

After UPDATE, I am running into:

ERROR:  record new has no field vev

The problem occurs with "vev� = new.az", I think the plpgsql parser
stops processing the field name "vev�" because "�" (code 245)
is not a standard ASCII character, it is from the Latin2 set.
I tried other non-international characters like "�" (code 233)
without success.

Could you please help, where to modify the sources to make this work?
I am using version 6.5.2.

Thank you in advice,
best wishes,            Kovacs, Zoltan




pgsql-sql by date:

Previous
From: "omid omoomi"
Date:
Subject: Re: [SQL] datetime fields have '60' in seconds field
Next
From: Jan Wieck
Date:
Subject: Re: [SQL] plpgsql bug(?)