Problem with PL/pgSQL in 7.03 - Mailing list pgsql-general

From Dmitry Chernikov
Subject Problem with PL/pgSQL in 7.03
Date
Msg-id 004201c086f0$c6be30c0$6901a8c0@cherhome
Whole thread Raw
List 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@beltel.ru

pgsql-general by date:

Previous
From: Jim Mercer
Date:
Subject: experience with replication?
Next
From: Gilles DAROLD
Date:
Subject: Re: Connection pooling