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

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

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

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" <pgsql@j-davis.com>
To: "Bob Pawley" <rjpawley@shaw.ca>
Cc: "Postgresql" <pgsql-general@postgresql.org>
Sent: Wednesday, November 29, 2006 4:41 PM
Subject: Re: [GENERAL] Version 8.1