[JDBC] default fetch size

2001-09-15 Thread Dave Thompson
Hi all, I'm doing some research into tightly coupling data mining applications to PostgreSQL, and have a couple of questions: 1) What's the default fetch size set by the jdbc driver (jdbc7.0-1.2.jar)? 2) Is there any way to change this other than by editing the source code? The setFetchSize

Re: [JDBC] isNullable()

2001-09-15 Thread Rene Pijlman
Attached is a patch that fixes ResultSetMetaData.isNullable() in the JDBC driver. This method is currently unimplemented and always returns ResultSetMetaData.columnNullable. This is obviously incorrect when a column is defined with NOT NULL or PRIMARY KEY. And we have to think of check

[JDBC] UpdateableResultSet patch (not finished yet!)

2001-09-15 Thread Ola Sundell
Hello, I have, for some time, now, been working on the updateable resultset class. Please have a look at http://www.miranda.org/~ola/jdbcupr.diff, and let me know what you think. It is only rudimentary at the moment. Things to consider: * Parsing of query. Very hackish at the moment. *

Re: [HACKERS] [JDBC] NULLs and sort order

2001-09-15 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: Rene Pijlman writes: Currently the JDBC driver says: - Backend = 7.2 sorts nulls higher than any other value in a domain. In other words: ascending means nulls at the end, descending means nulls at the start. - Backend 7.2 puts nulls at the end