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
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 |