Re: Trouble with NEW
От | Bob Pawley |
---|---|
Тема | Re: Trouble with NEW |
Дата | |
Msg-id | D2F4231F1FE24042B26A277C6C61A0CF@BobPC обсуждение исходный текст |
Ответ на | Re: Trouble with NEW (Alan Hodgson <ahodgson@simkin.ca>) |
Ответы |
Re: Trouble with NEW
Re: Trouble with NEW |
Список | pgsql-general |
It's an insert after trigger function. The table has a column named fluid_id. Bob -----Original Message----- From: Alan Hodgson Sent: Wednesday, July 18, 2012 11:15 AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Trouble with NEW On Wednesday, July 18, 2012 11:07:34 AM Bob Pawley wrote: > Hi > > I would appreciate some fresh eyes on this expression - > > update p_id.fluids > set fluid_short = > (select shape.text > from shape, num_search > where (select st_within(shape.wkb_geometry, > st_geometryn(num_search.the_geom4, 1)) = 'true') and text !~ '[0-9]') > where p_id.fluids.fluid_id = NEW.fluid_id; > > I receive an error ”record “new” has no field “fluid_id” “. > Is that run within an insert or update trigger function? Does the table it's on have a field named fluid_id? > Bob -- When the Athenians finally wanted not to give to society but for society to give to them, when the freedom they wished for most was freedom from responsibility, then Athens ceased to be free and was never free again.” -- Edward Gibbon -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: