BUG #13838: Problem in a table with integer primary key

Поиск
Список
Период
Сортировка
От ronan.vargas@gmail.com
Тема BUG #13838: Problem in a table with integer primary key
Дата
Msg-id 20151229170352.989.18565@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #13838: Problem in a table with integer primary key  (Feike Steenbergen <feikesteenbergen@gmail.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      13838
Logged by:          Ronan Lima Vargas
Email address:      ronan.vargas@gmail.com
PostgreSQL version: 9.1.14
Operating system:   Windows
Description:

Hi,
I'm using pgAdmin 1.20 for running some queries in my database. The
following error is occurring:

- Given a table (CLIENT) with a integer key (CLIENT_COD), when I run the
query:

select * from client where client_cod = 1

It doesn't return ANY row.

But when I run:

select * from client where (cast client_cod as text) = '1'

It returns ONE row.

In this moment, for me it would be hard to change DB version in order to see
if it will be solved. I've already tried to run an UPDATE, setting the same
CLIENT_COD, but it didn't work.

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

Предыдущее
От: Alain Laporte
Дата:
Сообщение: Re: BUG #13837: Files in pg_committs not deleted
Следующее
От: Feike Steenbergen
Дата:
Сообщение: Re: BUG #13838: Problem in a table with integer primary key