Re: Version 8.1
От | Bob Pawley |
---|---|
Тема | Re: Version 8.1 |
Дата | |
Msg-id | 007001c7140e$7bae32e0$8e904618@owner обсуждение исходный текст |
Ответ на | Version 8.1 (Bob Pawley <rjpawley@shaw.ca>) |
Ответы |
Re: Version 8.1
|
Список | 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@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 > > >
В списке pgsql-general по дате отправления: