I may as well bite the bullet.
Is this the syntax to use ???
CREATE OR REPLACE FUNCTION p_id.loopnumber()
RETURNS "trigger" AS $$
Update p_id.loop_sequence
Set function_ = library.devices.designation
From p_id.loops
where p_id.loop_sequence.monitor = p_id.devices.devices_id
and p_id.devices.device_number = library.devices.device_number ;
RETURN NULL;
END;
$$
LANGUAGE 'plpgsql' ;
CREATE TRIGGER loopnumbering AFTER INSERT ON p_id.loops
FOR EACH ROW EXECUTE PROCEDURE p_id.loopnumber();
----- Original Message -----
From: "Jeff Davis" <pgsql@xxxxxxxxxxx>
To: "Bob Pawley" <rjpawley@xxxxxxx>
Cc: "Postgresql" <pgsql-general@xxxxxxxxxxxxxx>
Sent: Wednesday, November 29, 2006 2:58 PM
Subject: Re: [GENERAL] Version 8.1
On Wed, 2006-11-29 at 14:42 -0800, Bob Pawley wrote:
I have just upgraded from v8.0 to 8.1.
In the new version I keep getting errors due to the absence of 'from'
-on triggers that showed no error in the old version.
Was insisting on the use of from a planned part of the upgrade?
Bob Pawley
See the "Migration to version 8.1" section of the release notes:
http://www.postgresql.org/docs/8.2/interactive/release-8-1.html
You can probably set the option to "true" in the config if you need to.
Regards,
Jeff Davis
