[BUGS] Use Postgresql in VB

2002-05-06 Thread smith
I am using postgresql as database server in my VB application. I use DAO(ODBCDirect) to connect to the database. It works with postgresql 7.1.x before.   When I upgraded the postgresql to 7.2.1, I found that the program does not work with the new version. The program gets DAO RecordSet from

[BUGS] PQescapeString and PQescapeBytea not exported during win 32 build

2002-05-06 Thread Rob Butler
Hello all, Simple "bug" Win 32 builds do not have PQescapeString or PQescapeBytea declared in the libpqdll.def file. This causes linking against libpqdll.lib to fail if either of the functions are called within a program. Add entries to the def file for these functions so they are exported

[BUGS] Postgresql JDBC Timestamp problem

2002-05-06 Thread Veit Guna
Hi. We're using a Postgresql 7.2 Database through the appropriate jdbc driver with Java 2. Selecting Data, updating etc. works fine except for the getTimestamp() method on the ResultSet. It delivers only a 3 digit fraction, although there's a 6 digit fraction stored in the db (timestamptz col

[BUGS] Bug in functions lower(), upper() with SQL_ASCII and LATIN1?

2002-05-06 Thread Hans Plum
Hello PostgreSQL Developers, I could not find a bug report to the functions lower() and upper() on the todo-list. Hopefully it is one, so that you are not bored by old tasks ... Take a look at the code and the reactions of PostgreSQL: When I try to convert german umlaute, e.g. Ä,Ö,Ü with lower(

[BUGS] Bug #658: psql does not start on cygwin

2002-05-06 Thread pgsql-bugs
Karl Schaefer ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description psql does not start on cygwin Long Description Setup: Windows 2000 SP2 Cygwin 1.3.10 cygipc 1.10 or 1.11 not sure, couldn't find a way to determine which version. po

[BUGS] Update bug.

2002-05-06 Thread Rick Szeto
Hi all, I have encountered a bug that I think is a major problem. I have a table as follows: CREATE TABLE registration ( registration_idint PRIMARY KEY; course_name varchar(6) NOT NULL; course_code varchar(6) NOT NULL; etc... ) Note: There is no index on course_n

Re: [BUGS] Bug in functions lower(), upper() with SQL_ASCII and LATIN1?

2002-05-06 Thread Tom Lane
Hans Plum <[EMAIL PROTECTED]> writes: > Take a look at the code and the reactions of PostgreSQL: When I try to > convert german umlaute, e.g. Ä,Ö,Ü with lower(), I get no lower letters. > With upper() it is the same problem vice verser ... This is determined by locale, not encoding. I think yo