Skip site navigation (1)
Skip section navigation (2)
pgsql-bugs 2002-02 Thread Index (1/2)
Last updated: Wed Jan 18 01:47:26 2012
220 messages
- Indexes not always used after inserts/updates/vacuum analyze Michael G. Martin (Thu 28 02:53)
- performance problems on updates on large tables with indexes Reinhard Max (Wed 27 16:29)
- function tree_level(varchar) (from OpenACS) no longer work under 7.2 Jean-Paul ARGUDO (Wed 27 08:07)
- Re: JDBC/JSP: Strange Problem Josh Burdick (Tue 26 16:24)
- Bug #604: string join problem pgsql-bugs (Tue 26 13:50)
- Bug #603: time() problems with PostgreSQL 7.2 pgsql-bugs (Tue 26 13:43)
- problems with configure connected with readline&history toxic (Tue 26 10:41)
- COPY FROM is not 8bit clean Darcy Buskermolen (Tue 26 04:19)
- Bug #602: Chinese characters query bug. pgsql-bugs (Mon 25 01:48)
- missing foreign key fails silently using COPY Lee Harr (Mon 25 01:11)
- Re: COPY when 'filename' is a directory Bruce Momjian (Sat 23 02:10)
- Re: Bug #534: factorial function Bruce Momjian (Sat 23 01:06)
- Bug #601: libpq needs a lo_truncate() or INV_TRUNC pgsql-bugs (Fri 22 23:07)
- Possible bug concerning LASTOID in 7.2 Coax (Fri 22 22:47)
- CURRENT_TIMESTAMP not work correctly insinde a transaction. Nicolas Paymal (Fri 22 13:42)
- Patch pgsql-7.2 AuthBlockSig Heiko Lehmann (Fri 22 10:53)
- Bug #600: how to run the Postgres postmaster with -i flag pgsql-bugs (Fri 22 08:24)
- Bug #599: ecpg does not parse correctly define and struct in the same file pgsql-bugs (Fri 22 05:23)
- [no subject] Hardeep (Thu 21 10:20)
- Full bug list Andy Marden (Thu 21 10:06)
- (plpgsql) DECLARE foo NUMERIC(5,2): syntax error at "(" Angus Lees (Thu 21 04:07)
- Trying Cygwin version of PostgreSQL Peter (Wed 20 23:51)
- Bug #598: optimizer: convert 'IN' to join pgsql-bugs (Wed 20 21:29)
- Re: Dates and year 2000 Andy Marden (Wed 20 21:10)
- schema error upgrading from 7.1 to 7.2 Vivek Khera (Wed 20 21:00)
- Bug #597: ResultSet.next() throws NullPointerException pgsql-bugs (Wed 20 01:20)
- Bug #596: bind to 127.0.0.1 in pgstat.c in secure server pgsql-bugs (Tue 19 22:36)
- Postgresql 7.1.3 not thread safe Alain Picard (Tue 19 01:24)
- 7.2 contrib RPM broken Greg Johnson (Mon 18 22:09)
- ecpg did not precompile declare cursor Bernhard Rückerl (Mon 18 21:54)
- Bug #595: No connection with jdbc since update to 7.2 pgsql-bugs (Mon 18 13:30)
- Bug #594: postgresql-odbc-7.2-1PGDG.i386.rpm lacks the actual shared library pgsql-bugs (Mon 18 11:51)
- Bug #593: postgresql-odbc-7.2-1PGDG.i386.rpm lacks the actual shared library pgsql-bugs (Mon 18 11:41)
- Bug #592: postgresql-odbc-7.2-1PGDG.i386.rpm lacks the actual shared library pgsql-bugs (Mon 18 11:35)
- crash on cash_words('21,474,836.48'::money) Eugene Pervago (Sun 17 21:45)
- Bug #591: Postgres apparently not identifying users created in Caps pgsql-bugs (Sat 16 18:22)
- psqlODBC Marc Breneiser (Sat 16 16:30)
- Possible Bug Chuck Handshy (Fri 15 22:25)
- Postgres 7.1 problem Ed Erdman (Fri 15 20:20)
- rename column and trigger on column Chris Sutton (Fri 15 17:42)
- Compiling error Torres Abarca Jaime (Fri 15 16:44)
- Bug with SQL-COPY in 7.2 Detlef Plotzky (Fri 15 14:07)
- Bug #590: Migration to Postgres 7.2 impossible when capitals are used in database name pgsql-bugs (Fri 15 12:06)
- Bug #589: JDBC KEY_SEQ in getImportedKey starts at 0 pgsql-bugs (Fri 15 11:51)
- (JDBC) KEY_SEQ in Foreign Key result set starts at 0, should be 1 David Goodenough (Fri 15 11:46)
- Bug in Postrgresql 7.2 migrating from 7.1.3 Ruud van den Brink (Fri 15 11:45)
- bugs Srinivasa R Chava (Thu 14 15:16)
- Bug #588: Postgresql will not build on AIX; cannot locate tcl library pgsql-bugs (Wed 13 22:10)
- Bug #587: Postgresql will not build on HP-UX 11.0 in debug mode pgsql-bugs (Wed 13 21:09)
- BLOB support is broken in the 7.2/7.3 JDBC driver, works in 7.1 driver Marc Lavergne (Wed 13 07:11)
- [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 (Wed 13 07:07)
- 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/something.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 very little chance of reading a document written on another computer, another word processor, or another network." -Tim Berners-Lee (Technology Review, July 1996) 01010101010101010101010101010101010101010101010101 -- 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 very little chance of reading a document written on another computer, another word processor, or another network." -Tim Berners-Lee (Technology Review, July 1996) 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/something.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 very little chance of reading a document written on another computer, another word processor, or another network." -Tim Berners-Lee (Technology Review, July 1996) 01010101010101010101010101010101010101010101010101 -- 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 very little chance of reading a document written on another computer, another word processor, or another network." -Tim Berners-Lee (Technology Review, July 1996) Marc Lavergne (Wed 13 06:46)
- createdb problem Isamary García (Tue 12 20:10)
- Bug #584: postgresql will not build on Solaris with cc pgsql-bugs (Tue 12 19:27)
- Bug #583: Wrong example in 7.2 Tutorial pgsql-bugs (Tue 12 18:55)
- Bug #582: no mapping for java.sql.Types.DECIMAL pgsql-bugs (Tue 12 01:38)
- Bug #581: Sequence cannot be deleted pgsql-bugs (Tue 12 01:26)
- Initdb Hangs Blossom, Eric (Tue 12 00:05)
- Bug #580: Optimizer uses seq scan only pgsql-bugs (Mon 11 22:51)
- Re: Bug #578: pg_dumpall from 7.1.3 can not be imported in 7.2.0 Tom Lane (Mon 11 19:47)
- Bug #579: Auto-VACUUM doesnt work pgsql-bugs (Mon 11 07:47)
- Bug #578: pg_dumpall from 7.1.3 can not be imported in 7.2.0 pgsql-bugs (Fri 08 19:03)
- Bug #577: incorect sort using order by pgsql-bugs (Fri 08 07:25)
- Bug #576: Can not compile IRIX + GCC pgsql-bugs (Fri 08 04:35)
- Bug #575: Build Problem with Postgresql 7.1.3 on Aix 4.3.3 with VisualAge 5.0 compiler resources: pgsql-bugs (Thu 07 15:17)
- Bug #574: can not create tables that start with "Clinic" pgsql-bugs (Thu 07 00:00)
- index and timestamp column Thomas Zehetbauer (Tue 05 17:25)
- Re: [CYGWIN] resource leak in 7.2 Henshall, Stuart - WCP (Tue 05 16:53)
Mail converted by MHonArc