Re: Version 8.1

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
>
>
>