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" 
To: "Bob Pawley" 
Cc: "Postgresql" 
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
> 
> 
>