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@j-davis.com>
To: "Bob Pawley" <rjpawley@shaw.ca>
Cc: "Postgresql" <pgsql-general@postgresql.org>
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
>
>
>
