Re: [BUGS] BUG #1862: ECPG Connect, host variable trailing blanks

2005-09-26 Thread Alvaro Herrera
On Mon, Sep 26, 2005 at 01:12:40PM -0700, [EMAIL PROTECTED] wrote: > >If Oracle strips trailing spaces on the client side, is that a > >configurable option? How would you insert significant trailing > >spaces into a VARCHAR column if the client library strips them? > > The Oracle precompiler (PRO

Re: [BUGS] BUG #1907: problem with function return as integer[]

2005-09-26 Thread Tom Lane
"Michael Kappler" <[EMAIL PROTECTED]> writes: > I compiled/linked a shared object against 7.4.5. My customer installed into > PostgreSQL 8.1beta1. My functions that return as integer[] give an empty > string (1 row) instead of the correct result (e.g., {{2,7}{4,5}}. Do I need > to recompile/link

Re: [BUGS] BUG #1862: ECPG Connect, host variable trailing blanks

2005-09-26 Thread Jim . Gray
>If Oracle strips trailing spaces on the client side, is that a >configurable option?  How would you insert significant trailing >spaces into a VARCHAR column if the client library strips them? The Oracle precompiler (PROC) has an option:   CHAR_MAP=CHARZ that allows retaining cobol's trailing bl

Re: [BUGS] String Comparision Weirdness

2005-09-26 Thread Tobias Brox
[Stephan Szabo - Mon at 06:07:48AM -0700] > It's more likely to be the locale in use. For example, on my machine, > given a file with -1 and 0. (...) > LANG="en_US" sort file > 0 > -1 Hah, those Americans don't even know how to count ;-) I find this weird, but it's clearly not a problem with pos

[BUGS] BUG #1907: problem with function return as integer[]

2005-09-26 Thread Michael Kappler
The following bug has been logged online: Bug reference: 1907 Logged by: Michael Kappler Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1beta1 Operating system: Red Hat Linux 9.0 Description:problem with function return as integer[] Details: I compiled/linke

[BUGS] BUG #1908: sql support chinese char error

2005-09-26 Thread wally
The following bug has been logged online: Bug reference: 1908 Logged by: wally Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3,8.0.2 Operating system: fc4,fc3,as4 Description:sql support chinese char error Details: when running the following sql clause,t

[BUGS] BUG #1911: Error in PSQLODBC.DLL using SQLTablePrivileges

2005-09-26 Thread Abel Pinto Muñoz
The following bug has been logged online: Bug reference: 1911 Logged by: Abel Pinto Muñoz Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Build 103 Operating system: Windows Description:Error in PSQLODBC.DLL using SQLTablePrivileges Details: With version

[BUGS] BUG #1909: Postgresql hang seems like an infinite loop

2005-09-26 Thread Joey P. Alim
The following bug has been logged online: Bug reference: 1909 Logged by: Joey P. Alim Email address: [EMAIL PROTECTED] PostgreSQL version: postgresql 7.3 Operating system: White Box Description:Postgresql hang seems like an infinite loop Details: hi, im using postgr

[BUGS] BUG #1910: pg_autovacuum failed on a table with very frequent r/w access

2005-09-26 Thread Antoine Bajolet
The following bug has been logged online: Bug reference: 1910 Logged by: Antoine Bajolet Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.2 Operating system: Linux 2.4.29 Description:pg_autovacuum failed on a table with very frequent r/w access Details: Hell

Re: [BUGS] String Comparision Weirdness

2005-09-26 Thread Stephan Szabo
On Mon, 26 Sep 2005, Tobias Brox wrote: > We had major problems after migrating the DB to a more powerful server; we > managed to locate the problem to a type conversion bug in our software. > Never the less, this thing puzzles us a lot: > > NBTEST2=# select '-1'>'0'; > ?column? > -- > t

Re: [BUGS] String Comparision Weirdness

2005-09-26 Thread Tobias Brox
[Tobias Brox - Mon at 12:17:33PM +0200] > At all servers we tested, strcmp("-1","0") returned > negative - at some -3 and at others -1, and not related to postgresql. Ehr, uncorrelated to the result of the evaluation of '-1'>'0' on postgresql, I mean. -- Notice of Confidentiality: This email is

[BUGS] String Comparision Weirdness

2005-09-26 Thread Tobias Brox
We had major problems after migrating the DB to a more powerful server; we managed to locate the problem to a type conversion bug in our software. Never the less, this thing puzzles us a lot: NBTEST2=# select '-1'>'0'; ?column? -- t (1 row) We've tried this query on several servers wit

[BUGS] System.InvalidCastException : Object cannot be cast from DBNull to other types

2005-09-26 Thread M . Bilgehan İMAMOĞLU
Hi, I write a program with C#. When i try to execute SQL query with pgAdmin III Query tool, i can see all data successfully. But i get “System.InvalidCastException : Object cannot be cast from DBNull to other types” error when execute sql query with c# codes. I can see BASLIK,FO1,FO2,FO