plpgsql bug(?)
От | Kovacs Zoltan |
---|---|
Тема | plpgsql bug(?) |
Дата | |
Msg-id | Pine.LNX.4.05.10001051123380.19358-100000@pc10.radnoti-szeged.sulinet.hu обсуждение исходный текст |
Список | 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 по дате отправления: