Re: Not able to update some rows in a table

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Marco Fochesato <marcofoc(at)gmail(dot)com>
Cc: "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:03:52
Message-ID: CAKFQuwbww8hd9YFqF=N4q0vp223Xq-sOSr=Q8pzymz9cTFDFCQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jul 2, 2018 at 8:59 AM, 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...
>

But you are able to determine which ones do fail, yes? Use one (or more)
of those...

Your problem is a mis-understanding of the data being operated on/with.
Figure out a way to show us the problem with real data.

David J.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2018-07-02 16:04:02 Re: Not able to update some rows in a table
Previous Message Marco Fochesato 2018-07-02 15:59:27 Re: Not able to update some rows in a table