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