| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Marco Fochesato <marcofoc(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Not able to update some rows in a table |
| Date: | 2018-07-02 15:13:28 |
| Message-ID: | 4bb08fbe-8ff2-df51-8bc2-4e5e2239d7ec@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 07/02/2018 07:51 AM, Marco Fochesato wrote:
> Dear all,
> I have a table with 21 columns.
> Primary key is done with 20 of these colums.
Do you mean the Primary Key is constructed from 20 columns?
>
> I have 3.313 records.
> I don't know why, but I'm not able to update some of these records.
What is the SQL you are using?
Are there any error messages and if so what are they?
> I don't understand, it seems that I'm not able to fetch.
> It happens with Pgadmin, with Python Psycopg2 and also through
> Libreoffice Base.
>
> Looking to the properties of the table in Pgadmin, I can see only the
> estimated number
> of rows. Counted rows are 'not counted'.
>
> --
> Marco Fochesato
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2018-07-02 15:13:53 | Re: except all & WITH - syntax error? |
| Previous Message | Moreno Andreo | 2018-07-02 15:07:10 | Re: Not able to update some rows in a table |