Mailing lists [pgsql-bugs]
- Postgresql 7.1.3 not thread safe Alain Picard
- bugs Srinivasa R Chava
- Bug in Postrgresql 7.2 migrating from 7.1.3 Ruud van den Brink
- (JDBC) KEY_SEQ in Foreign Key result set starts at 0, should be 1 David Goodenough
- Bug with SQL-COPY in 7.2 Detlef Plotzky
- [Fwd: BLOB support is broken in the 7.2/7.3 JDBC driver, works in 7.1 driver java.sql.SQLException: ERROR: oidin: error in "\377\330\377\340... I'm on Linux 2.4.16 using JDK 1.4.0 but it fails in 1.3.1 as well. Here's a quick reproducible test case: -- start -- package sample.java.jdbc; import java.sql.*; import java.io.*; import java.util.*; class testBlob { public static void main(String args[]) { new testBlob(); System.exit(0); } public testBlob() { System.out.println("Let's begin the test ..."); String v_username = "postgre"; String v_password = "postgre"; String v_database = "jdbc:postgresql://127.0.0.1/TEST"; PreparedStatement v_pstmt = null; try { DriverManager.registerDriver(new org.postgresql.Driver()); Connection v_conn = DriverManager.getConnection( v_database, v_username, v_password); v_conn.setAutoCommit(false); File v_file = new File("/home/postgre/someth! ing.jpg"); FileInputStream v_fis = new FileInputStream(v_file); v_pstmt = v_conn.prepareStatement( "insert into lob_test (id,data) values (?,?)"); v_pstmt.setInt(1,2); v_pstmt.setBinaryStream(2,v_fis,(int)v_file.length()); System.out.println("now you see me"); v_pstmt.executeUpdate(); System.out.println("now you don't"); v_conn.commit(); v_fis.close(); v_pstmt.close(); } catch (IOException e_io) { System.out.println(e_io); } catch (SQLException e_sql) { System.out.println(e_sql); } System.out.println("You'll only get here with the 7.1 driver!"); } } -- end -- 01010101010101010101010101010101010101010101010101 Marc P. Lavergne [wk:407-648-6996] Product Development richLAVA Corporation -- "Anyone who slaps a 'this page is best viewed with Browser X' label on a Web page appears to be yearning for the bad old days, before the Web, when you had v! ery little chance of reading a document written on another computer, a Marc Lavergne
- createdb problem Isamary García
- rename column and trigger on column Chris Sutton
- Postgres 7.1 problem Ed Erdman
- Compiling error Torres Abarca Jaime
- BLOB support is broken in the 7.2/7.3 JDBC driver, works in 7.1 driver Marc Lavergne
- Possible Bug Chuck Handshy
- Re: bugs Tom Lane
- psqlODBC mbreneiser@whgrp.com (Marc Breneiser)
- Postgresql 7.1.3 not thread safe Alain Picard
- 7.2 contrib RPM broken Greg Johnson
- ecpg did not precompile declare cursor Bernhard Rückerl
- Re: Compiling error Tom Lane
- crash on cash_words('21,474,836.48'::money) Eugene Pervago
- Re: Possible Bug Tom Lane
- Re: Postgresql 7.1.3 not thread safe Tom Lane
- Re: crash on cash_words('21,474,836.48'::money) Tom Lane
- Bug #596: bind to 127.0.0.1 in pgstat.c in secure server pgsql-bugs@postgresql.org
- Re: Postgresql 7.1.3 not thread safe Alain Picard
- Bug #597: ResultSet.next() throws NullPointerException pgsql-bugs@postgresql.org