| From: | "Dmitry Chernikov" <cher(at)beltel(dot)ru> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Problem with PL/pgSQL in 7.03 |
| Date: | 2001-01-25 16:44:27 |
| Message-ID: | 004201c086f0$c6be30c0$6901a8c0@cherhome |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi
I migrated from version 6.5 to 7.03
My function (see below) doesn't work in 7.03, but it works in 6.5 .
CREATE FUNCTION "projects_update_function" ( ) RETURNS opaque AS '
begin
if TG_OP=''UPDATE'' then
NEW."Last Modify":=''now'';
return NEW;
end if;
end;
' LANGUAGE 'plpgsql';
CREATE TRIGGER "Projects_Update" BEFORE UPDATE ON "Projects"
FOR EACH ROW EXECUTE PROCEDURE "projects_гpdate_function" ();
NOTICE: plpgsql: ERROR during compile of projects_update_function near line 2
ERROR: unterminated "
Dmitry Chernikov cher(at)beltel(dot)ru
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter T Mount | 2001-01-25 17:15:48 | Re: Connection pooling |
| Previous Message | Aggarwal , Ajay | 2001-01-25 16:19:03 | 2 or more columns of type 'serial' in a table |