Обсуждение: national characters in plpgsql

Поиск
Список
Период
Сортировка

national characters in plpgsql

От
"Artur Kokoszka"
Дата:
This message was sent from Geocrawler.com by "Artur Kokoszka" <kkokoszk@ite.waw.pl>
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