Re: Not able to update some rows in a table

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Not able to update some rows in a table
Дата
Msg-id 4bb08fbe-8ff2-df51-8bc2-4e5e2239d7ec@aklaver.com
обсуждение исходный текст
Ответ на Not able to update some rows in a table  (Marco Fochesato <marcofoc@gmail.com>)
Список 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.klaver@aklaver.com


В списке pgsql-general по дате отправления:

Предыдущее
От: Moreno Andreo
Дата:
Сообщение: Re: Not able to update some rows in a table
Следующее
От: Tom Lane
Дата:
Сообщение: Re: except all & WITH - syntax error?