Have noticed it is not the same function...
Theodore Petrosky wrote:
Great I got the double quotes in the trigger... like
this:
CREATE FUNCTION notify_jobinfo() RETURNS "trigger"
AS '
BEGIN
EXECUTE ''NOTIFY
"''||TG_RELNAME||''_''||NEW.jobnumber||''"'';
RETURN NEW;
END
' LANGUAGE plpgsql;
and it
Ignore that last post of course I have a
production machine and a development machine and I
should have updated the development machine before
opening my mouth...
Everything works just fine thanks.
Ted
--- Theodore Petrosky <[EMAIL PROTECTED]> wrote:
> Great I got the double quotes in t
Great I got the double quotes in the trigger... like
this:
CREATE FUNCTION notify_jobinfo() RETURNS "trigger"
AS '
BEGIN
EXECUTE ''NOTIFY
"''||TG_RELNAME||''_''||NEW.jobnumber||''"'';
RETURN NEW;
END
' LANGUAGE plpgsql;
and it works great... however, i did a pg_dump of the
db to back it up.
