national characters in plpgsql

From: "Artur Kokoszka" <archiver(at)db(dot)geocrawler(dot)com>
To: pgsql-sql(at)hub(dot)org
Subject: national characters in plpgsql
Date: 1999-11-13 22:30:35
Message-ID: 199911132230.OAA07882@www.geocrawler.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

This message was sent from Geocrawler.com by "Artur Kokoszka" <kkokoszk(at)ite(dot)waw(dot)pl>
Be sure to reply to that address.

There is a problem with this function:
create function fn_ZakadyLudzie_XXXS() returns
opaque as '
--
-- REFERENTIAL INTEGRITY CHECKING CODE BETWEEN
Zakady AND Ludzie
-- ENSURES THAT INTEGRITY IS MAINTAINED AFTER AN
UPDATE ON TABLE Ludzie (Slave)
-- Generated by PgUpT 99-11-04
--
DECLARE
l_m Zakady%ROWTYPE;
l_err_text text;
l_Flag integer;
BEGIN
l_Flag := 0;
if new.IDZakadu IS NOT NULL then
l_Flag := 1;
end if;
if l_Flag > 0 then
SELECT * FROM Zakady INTO l_m
WHERE
IDZakadu = new.IDZakadu
;
if not found then
l_err_text := f_Exception(3201,
''Zakady,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_zakadyludzie_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

Browse pgsql-sql by date

  From Date Subject
Next Message juman 1999-11-14 10:25:29 Verificate values in other table?
Previous Message Tom Lane 1999-11-13 19:41:12 Re: [SQL] Porting MySQL's DESCRIBE and ENUM features