[BUGS] The column index is out of range in PostgreSQL + resolve

Dear All,   SQL Query is running perfect from PG Admin but it gives error “The column index is out of range “ when running through java application.Please advise me how to solve this issue.   Best Regards Murali

[BUGS] BUG #3394: Partial search not working

The following bug has been logged online: Bug reference: 3394 Logged by: Murali Doss Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Linux Description:Partial search not working Details: Dear All, Partial search query is not working

[BUGS] BUG #3395: varchar[] --> Warning vendor specific

The following bug has been logged online: Bug reference: 3395 Logged by: Murali Doss Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: Window XP Description:varchar[] --> Warning vendor specific Details: In postgresql ,i am using varc

Re: [BUGS] BUG #3394: Partial search not working

No result but the matching data is available in table -Original Message- From: Heikki Linnakangas [mailto:[EMAIL PROTECTED] On Behalf Of Heikki Linnakangas Sent: Tuesday, June 19, 2007 1:17 PM To: Murali Doss Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #3394: Partial search not

Re: [BUGS] BUG #3394: Partial search not working

ry to find the local settings and encoding. Regards Murali Doss T.S. -Original Message- From: Michael Fuhr [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 19, 2007 3:51 PM To: Murali Doss Cc: Heikki Linnakangas; pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #3394: Partial search not working

Re: [BUGS] BUG #3394: Partial search not working

Hi Zdenek, Thanks for your effort. Database encoding for Solaris OS is SQL_ASCII but it's UTF8 in Linux OS. How to change the database encoding to sql_ascii for linux OS? Regards Murali Doss T.S. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tu

Re: [BUGS] BUG #3394: Partial search not working

nt: Tuesday, June 19, 2007 6:44 PM To: Murali Doss Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #3394: Partial search not working AFAIK, you will need to recreate the database. See "CREATE DATABASE" command for details, but something like "CREATE DATABASE FOO WITH ENCODING

Re: [BUGS] BUG #3394: Partial search not working

ot; Server Encoding "SQL_ASCII" And it's same in Solaris and Window OS where the query is returning expected results. Regards Murali -Original Message- From: Alvaro Herrera [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 19, 2007 7:30 PM To: Murali Doss Cc: Douglas Tol

[BUGS] BUG #3397: change the pg_setting

The following bug has been logged online: Bug reference: 3397 Logged by: Murali Doss Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.8 Operating system: Linux Description:change the pg_setting Details: Dear All, How to change the pg_setting from en_US.UTF

Re: [BUGS] BUG #3394: Partial search not working

Dear All, How to change the pg_setting from en_US.UTF-8 to "C". lc_collate - en_US.UTF-8 lc_ctype- en_US.UTF-8 lc_messages - en_US.UTF-8 lc_monetary - en_US.UTF-8 lc_numeric - en_US.UTF-8 lc_time - en_US.UTF-8 Regards Murali Doss T.S. -Original Message

[BUGS] BUG #4188: Array field column (varchar[]) cannot be cast to type "text"

The following bug has been logged online: Bug reference: 4188 Logged by: Murali Doss Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.6 Operating system: Linux Description:Array field column (varchar[]) cannot be cast to type "text" Details: De