[HACKERS] JDBC prepared statements: actually not server prepared

2004-06-20 Thread Henner Zeller
Hi, While tracking down a query with a JDBC prepared statement, I noticed, that the statement actually wasn't prepared but sent to the server as 'normal' Statement. In my case, this led to a very slow query since the normal statement does not propagate the correct type -- in my case I queried an

Re: [HACKERS] [GENERAL] 7.3 - pg_atoi: zero-length string

2002-12-03 Thread Henner Zeller
Hi, | What is the solution of other dbs ( oracle, db2 .. ) to: | insert into table (num) value (''); ? | | I assume they would fail too. The Oracle behaviour is: --- oracle create table foonum (x number(5)); oracle insert into foonum values (''); oracle select * from foonum; + X

[HACKERS] PG 7.3: Query Meta Data with the JDBC-driver

2002-12-02 Thread Henner Zeller
Hi, Just compiled the 7.3 branch from source and made some tests using the JDBC driver coming with it. I did some tests with the henplus JDBC-shell and noticed some problems quering the database meta data: o the foreign key name is 'wierd' --- DatabaseMetaData meta =