Indeed there is an id field. That's the ticket!
And thanks much.
From: Adrian Klaver [mailto:adrian(dot)klaver(at)gmail(dot)com]
Sent: Tuesday, February 28, 2012 12:48 PM
Cc: Lummis, Patrick J; Bartosz Dmytrak
Subject: Re: [GENERAL] Stored Procedure Record Updates using For Loops -
On Tuesday, February 28, 2012 12:35:58 pm Lummis, Patrick J wrote:
> Hi Bartek,
> Thanks for the quick response.
> Syntax error cleared up and loads fine but executing the stored
> procedure fails to update the row.
From the usage I guessing this function is not being used in a trigger.
As such the ROW variable exists outside the table. If you want to UPDATE
the table you are going to have to do a hybrid of what you have:
update workorder set wfstatus='failed' where id=workorderRecord.id
assuming there is an 'id' field of some sort.
In response to
pgsql-general by date
|Next:||From: Andy Colson||Date: 2012-02-28 22:21:32|
|Subject: Re: strategies for dealing with frequently updated tables|
|Previous:||From: dennis jenkins||Date: 2012-02-28 22:01:23|
|Subject: Re: accumulating handles problem on machine running postgresql|