national characters in plpgsql

Поиск
Список
Период
Сортировка
От Artur Kokoszka
Тема national characters in plpgsql
Дата
Msg-id 199911132230.OAA07882@www.geocrawler.com
обсуждение исходный текст
Список pgsql-sql
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


В списке pgsql-sql по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] Porting MySQL's DESCRIBE and ENUM features
Следующее
От: "juman"
Дата:
Сообщение: Verificate values in other table?