Re: [BUGS] BUG #3493: Cannot find data with = operator

2007-07-30 Thread Michał Niklas
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

Re: [BUGS] BUG #3493: Cannot find data with = operator

2007-07-27 Thread Douglas Toltzman
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

Re: [BUGS] BUG #3493: Cannot find data with = operator

2007-07-27 Thread Tom Lane
"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

Re: [BUGS] BUG #3493: Cannot find data with = operator

2007-07-27 Thread Michał Niklas
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

Re: [BUGS] BUG #3493: Cannot find data with = operator

2007-07-27 Thread Alvaro Herrera
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

[BUGS] BUG #3493: Cannot find data with = operator

2007-07-27 Thread Michal Niklas
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