Re: Version 8.1

Re: Version 8.1

Thanks Jeff

I'm going through a learning curve. I don't need to add possible 
instability.

Thanks again.

Bob
----- Original Message ----- 
From: "Jeff Davis" 
To: "Bob Pawley" 
Cc: "Postgresql" 
Sent: Wednesday, November 29, 2006 4:41 PM
Subject: Re: [GENERAL] Version 8.1


> On Wed, 2006-11-29 at 15:31 -0800, Bob Pawley wrote:
>> I may as well bite the bullet.
>>
>
> If you're going to migrate to 8.1, you might consider migrating to 8.2
> since it's almost released. That depends on your timeline though; 8.1 is
> a safer bet if you need stability now.
>
>> 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();
>>
>
> I think you need library.devices and p_id.devices in the fromlist. Also,
> why is p_id.loops in the fromlist if it's not a part of the WHERE?
>
> Regards,
> Jeff Davis
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq 

Version 8.1

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

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

Re: Version 8.1

On Wed, 2006-11-29 at 15:31 -0800, Bob Pawley wrote:
> I may as well bite the bullet.
> 

If you're going to migrate to 8.1, you might consider migrating to 8.2
since it's almost released. That depends on your timeline though; 8.1 is
a safer bet if you need stability now.

> 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();
> 

I think you need library.devices and p_id.devices in the fromlist. Also,
why is p_id.loops in the fromlist if it's not a part of the WHERE?

Regards,
	Jeff Davis

Re: Version 8.1

On Wednesday 29 November 2006 02:42 pm, 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

http://www.postgresql.org/docs/8.1/interactive/runtime-config-compatible.html
See add_missing_from (boolean)
-- 
Adrian Klaver	
aklaver@comcast.net