Received: from www.geocrawler.com (sourceforge.net [209.81.8.17]) by hub.org (8.9.3/8.9.3) with ESMTP id RAA16451 for ; Sat, 13 Nov 1999 17:30:37 -0500 (EST) (envelope-from nobody@www.geocrawler.com) Received: (from nobody@localhost) by www.geocrawler.com (8.9.3/8.9.3) id OAA07882; Sat, 13 Nov 1999 14:30:35 -0800 Date: Sat, 13 Nov 1999 14:30:35 -0800 Message-Id: <199911132230.OAA07882@www.geocrawler.com> To: pgsql-sql@hub.org Subject: national characters in plpgsql From: "Artur Kokoszka" Reply-To: "Artur Kokoszka" This message was sent from Geocrawler.com by "Artur Kokoszka" Be sure to reply to that address. There is a problem with this function: create function fn_ZakładyLudzie_XXXS() returns opaque as ' -- -- REFERENTIAL INTEGRITY CHECKING CODE BETWEEN Zakłady AND Ludzie -- ENSURES THAT INTEGRITY IS MAINTAINED AFTER AN UPDATE ON TABLE Ludzie (Slave) -- Generated by PgUpT 99-11-04 -- DECLARE l_m Zakłady%ROWTYPE; l_err_text text; l_Flag integer; BEGIN l_Flag := 0; if new.IDZakładu IS NOT NULL then l_Flag := 1; end if; if l_Flag > 0 then SELECT * FROM Zakłady INTO l_m WHERE IDZakładu = new.IDZakładu ; if not found then l_err_text := f_Exception(3201, ''Zakłady,Ludzie''); raise exception ''%'', l_err_text; end if; return NULL; else return new; end if; END;' language 'plpgsql'; When I try to insert a row in table Ludzie, I've got a message: NOTICE: plpgsql: ERROR during compile of fn_zakładyludzie_xxxs near line 7 ERROR: parse error at or near "Zak" I suppose there is a problem with characters like "ł", but I don't know why. Altough there are many characters like this one in the database (eg. names of rows, columns or indexes they don't make any errors. Geocrawler.com - The Knowledge Archive