Tom Lane wrote:
"Michal Niklas" <[EMAIL PROTECTED]> writes:
This is problem in just one table in one database. It works as expected on
just created tmp table and on other customers databases. It works if I
change 'KIOSK ' to other text. I tried 'vacuum analyze' on this table but
it didn't
The schema specification you provided doesn't even include the column
"name", which you are selecting in your original message. What is
the field type of "name" ?
On Jul 27, 2007, at 6:55 AM, Michał Niklas wrote:
Alvaro Herrera wrote:
Michal Niklas wrote:
isof_customer=# insert into cu
"Michal Niklas" <[EMAIL PROTECTED]> writes:
> This is problem in just one table in one database. It works as expected on
> just created tmp table and on other customers databases. It works if I
> change 'KIOSK ' to other text. I tried 'vacuum analyze' on this table but
> it didn't help.
REINDEX
Alvaro Herrera wrote:
Michal Niklas wrote:
isof_customer=# insert into customers (name) values ('KIOSK ');
INSERT 437819002 1
isof_customer=# select id,name from customers where name='KIOSK ';
id | name
---+--
(0 rows)
isof_customer=# select id,name from custome
Michal Niklas wrote:
> isof_customer=# insert into customers (name) values ('KIOSK ');
> INSERT 437819002 1
> isof_customer=# select id,name from customers where name='KIOSK ';
> id | name
> ---+--
> (0 rows)
>
> isof_customer=# select id,name from customers where nam
The following bug has been logged online:
Bug reference: 3493
Logged by: Michal Niklas
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.9
Operating system: Linux, x86-64, debian
Description:Cannot find data with = operator
Details:
I cannot find just inserte