Lists: | pgsql-general |
---|
From: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
---|---|
To: | Postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | Version 8.1 |
Date: | 2006-11-29 22:42:35 |
Message-ID: | 005501c71407$aff84b00$8e904618@owner |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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
From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
---|---|
To: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
Cc: | Postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Version 8.1 |
Date: | 2006-11-29 22:58:48 |
Message-ID: | 1164841128.7773.126.camel@dogma.v10.wvs |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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
From: | Adrian Klaver <aklaver(at)comcast(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
Subject: | Re: Version 8.1 |
Date: | 2006-11-29 23:06:57 |
Message-ID: | 200611291506.57143.aklaver@comcast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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(at)comcast(dot)net
From: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
---|---|
To: | Jeff Davis <pgsql(at)j-davis(dot)com> |
Cc: | Postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Version 8.1 |
Date: | 2006-11-29 23:31:14 |
Message-ID: | 007001c7140e$7bae32e0$8e904618@owner |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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(at)j-davis(dot)com>
To: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
Cc: "Postgresql" <pgsql-general(at)postgresql(dot)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
>
>
>
From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
---|---|
To: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
Cc: | Postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Version 8.1 |
Date: | 2006-11-30 00:41:15 |
Message-ID: | 1164847275.7773.136.camel@dogma.v10.wvs |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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
From: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
---|---|
To: | Jeff Davis <pgsql(at)j-davis(dot)com> |
Cc: | Postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Version 8.1 |
Date: | 2006-11-30 01:21:15 |
Message-ID: | 001401c7141d$da0fe3b0$8e904618@owner |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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(at)j-davis(dot)com>
To: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
Cc: "Postgresql" <pgsql-general(at)postgresql(dot)org>
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