[BUGS] Help on clarification of supported platform for Postgres 8.2

2007-07-27 Thread Siraj Khan
Dear Team, I am working for small firm in Mumbai, India. We are interested in running Postgres 8.2 database on IBM unix platform (Power5 processor). Need your help in confirmation whether Postgres 8.2 runs on AIX 5.3 OS on Power5 cpu SLES 9 OS on Power5 platform Please help

Re: [BUGS] Help on clarification of supported platform for Postgres 8.2

2007-07-27 Thread Stefan Kaltenbrunner
Siraj Khan wrote: Dear Team, I am working for small firm in Mumbai, India. We are interested in running Postgres 8.2 database on IBM unix platform (Power5 processor). Need your help in confirmation whether Postgres 8.2 runs on * AIX 5.3 OS on Power5 cpu this is a platform that is both

Re: [BUGS] BUG #3494: may be Query Error: subplan does not executed

2007-07-27 Thread Heikki Linnakangas
Sergey Burladyan wrote: > i have query with join of two table and 'where' filter it result by subplan > which have references to join result, but this subplan not executed and > result is incorrect. This subplan also not exist in explain analyze output. I can reproduce this on 8.1 and 8.2 branch h

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 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] psql prompting for password. Can we suppress it?

2007-07-27 Thread Milen A. Radev
Pradeep Rai написа: > Hello, > > We are trying to perform bulk insert into PostGre database with the help of > a text file (containing n INSERT statements), and then invoking psql command > from a batch file. > > "psql -d -f -h -U " > > The issue is that the psql command window prompts for

[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

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 #3494: may be Query Error: subplan does not executed

2007-07-27 Thread Sergey Burladyan
The following bug has been logged online: Bug reference: 3494 Logged by: Sergey Burladyan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.9 Operating system: CentOS release 5 (Final) Description:may be Query Error: subplan does not executed Details: i have

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

[BUGS] psql prompting for password. Can we suppress it?

2007-07-27 Thread Pradeep Rai
Hello, We are trying to perform bulk insert into PostGre database with the help of a text file (containing n INSERT statements), and then invoking psql command from a batch file. "psql -d -f -h -U " The issue is that the psql command window prompts for the password. Have you got any idea h