[BUGS] Re: BUG #3924: Create Database with another encoding as the encoding from postgres

2008-02-06 Thread Pit M.
Heikki Linnakangas wrote: Yes, that's an intentional change. From release notes: I had the same problem this morning. We provide a sample database with LATIN1 encoding (included in our setup). So how can i change my encoding to have a database that can be used with PG 8.1; 8.1; 8.2 and 8.3 wit

Re: [BUGS] ERROR: invalid input syntax for integer: ""

2007-05-23 Thread Pit M.
It would have failed if you had run the cursor far enough to fetch one of the bad rows. regards, tom lane The difference is that in one case the query fails and in the other the FETCH command fails. Our problem is that if a query succeeds we use a count(*) of that q

[BUGS] ERROR: invalid input syntax for integer: ""

2007-05-23 Thread Pit M.
Following query fails in pgAdmin which is OK because the field PLZZ contains characters: select * from "PERSONEN" where (CAST("PERSONEN"."PLZZ" AS INTEGER) >= 7 ); but if using the same query with a cursor ist works: START TRANSACTION; DECLARE c21112234 SCROLL CURSOR FOR select * from "