Re: Not able to update some rows in a table

From: Charles Clavadetscher <clavadetscher(at)swisspug(dot)org>
To: Marco Fochesato <marcofoc(at)gmail(dot)com>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Not able to update some rows in a table
Date: 2018-07-02 16:04:37
Message-ID: 56DCEFE4-F5D0-4FFE-A41F-40056B54B4A0@swisspug.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On 02.07.2018, at 17:59, Marco Fochesato <marcofoc(at)gmail(dot)com> wrote:
>
>
>>
>> I would suggest writing a self-contained script that creates the table, inserts a single record, and updates that record. Present that for consideration along with a description or capture of the results of running the script on your machine.
>
> But not all the records fail the update...
>
>

Do you have a trigger or a rule intercepting the update? You may see this with \d in a console.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2018-07-02 16:06:10 Re: Not able to update some rows in a table
Previous Message Rob Sargent 2018-07-02 16:04:02 Re: Not able to update some rows in a table