Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
pgsql-bugs - February 2002
Prev | Next
2002-02-01
- Re: date format problem Thomas Lockhart (04:06)
- strange bug with vacuum hubert depesz lubaczewski (09:06)
- Re: New to Postgresql - Backend timeout /JDBC Stefano Reksten (10:49)
- Bug #570: \d in psql does not show triggers pgsql-bugs (13:41)
- Re: Bug #570: \d in psql does not show triggers Tom Lane (14:52)
- Re: strange bug with vacuum Stephan Szabo (16:27)
- Re: New to Postgresql - Backend timeout /JDBC Peter V. Cooper (17:59)
- Re: Bug to restore OID with pg_restore Bruce Momjian (18:51)
- Re: plpgsql support Stephan Szabo (19:00)
- Re: initdb problems Grant Johnson (19:24)
- Re: psql in 7.2devel loops Tom Lane (19:43)
- Re: Queries Errors Tom Lane (19:45)
- Re: initdb problems Tom Lane (19:46)
- Re: Sun Solaris 2.5.1 Seg Faults PostgreSQL7.1.3 build com Riendeau, Mike (21:03)
- Re: Sun Solaris 2.5.1 Seg Faults PostgreSQL7.1.3 build com mands Tom Lane (21:14)
- Re: array_dims function is poorly behaved Tom Lane (22:11)
- Re: PostgresSQL 7.1.3 not parsing SELECT portion of SQL correctly Tom Lane (22:53)
2002-02-02
- JDBC- SQLException results returned? Eric Scroger (01:08)
2002-02-03
- Bug #571: Impossible to completly support JDBC pgsql-bugs (19:24)
2002-02-04
- Bug #572: Double Format pgsql-bugs (06:36)
- Re: Bug #572: Double Format Peter Eisentraut (16:12)
2002-02-05
- resource leak in 7.2 Tom Pfau (14:47)
- Bug #573: fails to make darwin 5.2 pgsql-bugs (16:00)
- Re: resource leak in 7.2 Tom Lane (16:20)
- Re: Bug #573: fails to make darwin 5.2 Tom Lane (16:41)
- Re: [CYGWIN] resource leak in 7.2 Henshall, Stuart - WCP (16:49)
- Re: [CYGWIN] resource leak in 7.2 Tom Lane (17:10)
- Re: resource leak in 7.2 Tom Pfau (17:11)
- Re: [CYGWIN] resource leak in 7.2 Tom Pfau (17:12)
- index and timestamp column Thomas Zehetbauer (17:26)
- Re: resource leak in 7.2 Tom Lane (18:07)
- Re: [BUGS] resource leak in 7.2 Jason Tishler (20:02)
- Re: [CYGWIN] resource leak in 7.2 Tom Pfau (21:49)
2002-02-07
- Bug #574: can not create tables that start with "Clinic" pgsql-bugs (00:00)
- Re: Bug #574: can not create tables that start with "Clinic" Peter Eisentraut (00:20)
- Re: Bug #574: can not create tables that start with "Clinic" Edwin Grubbs (00:20)
- Bug #575: Build Problem with Postgresql 7.1.3 on Aix 4.3.3 with VisualAge 5.0 compiler resources: pgsql-bugs (15:17)
- Re: Bug #575: Build Problem with Postgresql 7.1.3 on Aix 4.3.3 with VisualAge 5.0 compiler resources: Tom Lane (17:34)
2002-02-08
- Bug #576: Can not compile IRIX + GCC pgsql-bugs (04:35)
- Re: Bug #576: Can not compile IRIX + GCC Bruce Momjian (04:53)
- Bug #577: incorect sort using order by pgsql-bugs (07:25)
- Re: Bug #576: Can not compile IRIX + GCC Luis Amigo (09:29)
- Re: [BUGS] resource leak in 7.2 Jason Tishler (11:59)
- Re: Bug #577: incorect sort using order by Tom Lane (16:09)
- Re: [CYGWIN] resource leak in 7.2 Hiroshi Inoue (18:14)
- Bug #578: pg_dumpall from 7.1.3 can not be imported in 7.2.0 pgsql-bugs (19:03)
- Re: Bug #578: pg_dumpall from 7.1.3 can not be imported in Stephan Szabo (19:32)
2002-02-09
- Re: Bug #578: pg_dumpall from 7.1.3 can not be imported in Rainer Tammer (06:58)
2002-02-10
- Re: Bug #578: pg_dumpall from 7.1.3 can not be imported in 7.2.0 Tom Lane (23:48)
2002-02-11
- Bug #579: Auto-VACUUM doesnt work pgsql-bugs (07:47)
- Re: Bug #579: Auto-VACUUM doesnt work Tom Lane (16:07)
- Re: Bug #579: Auto-VACUUM doesnt work Peter Eisentraut (16:13)
- Re: Bug #578: pg_dumpall from 7.1.3 can not be imported in 7.2.0 Tom Lane (19:46)
- Bug #580: Optimizer uses seq scan only pgsql-bugs (22:51)
- Re: Bug #580: Optimizer uses seq scan only Tom Lane (23:21)
- Re: Bug #580: Optimizer uses seq scan only Stephan Szabo (23:43)
2002-02-12
- Initdb Hangs Blossom, Eric (00:01)
- Re: Initdb Hangs Blossom, Eric (00:09)
- Bug #581: Sequence cannot be deleted pgsql-bugs (01:26)
- Bug #582: no mapping for java.sql.Types.DECIMAL pgsql-bugs (01:38)
- Re: Bug #581: Sequence cannot be deleted Stephan Szabo (02:14)
- Re: Bug #581: Sequence cannot be deleted Tom Lane (02:17)
- Bug #583: Wrong example in 7.2 Tutorial pgsql-bugs (18:55)
- Bug #584: postgresql will not build on Solaris with cc pgsql-bugs (19:27)
- Bug #584: postgresql will not build on Solaris with cc pgsql-bugs (19:34)
- Bug #584: postgresql will not build on Solaris with cc pgsql-bugs (19:54)
- Re: [BUGS] Bug #581: Sequence cannot be deleted Brent Verner (20:09)
- createdb problem Isamary García (20:10)
- Re: [BUGS] Bug #581: Sequence cannot be deleted Tom Lane (20:48)
- Re: Bug #584: postgresql will not build on Solaris with cc Tom Lane (21:14)
- Re: [BUGS] Bug #581: Sequence cannot be deleted Ian Barwick (21:58)
- Re: Bug #584: postgresql will not build on Solaris with cc Nishad Prakash (22:10)
- Re: [BUGS] Bug #581: Sequence cannot be deleted Tom Lane (22:17)
- Re: Bug #583: Wrong example in 7.2 Tutorial Bruce Momjian (22:24)
- Re: [BUGS] Bug #581: Sequence cannot be deleted Tom Innes (22:25)
2002-02-13
- 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 --01010101010101010101010101010101010101010101010101Marc P. Lavergne [wk:407-648-6996]Product DevelopmentrichLAVA Corporation--"Anyone who slaps a 'this page is best viewed withBrowser X' label on a Web page appears to beyearning for the bad old days, before the Web,when you had very little chance of reading adocument written on another computer, another wordprocessor, or another network."-Tim Berners-Lee (Technology Review, July 1996)01010101010101010101010101010101010101010101010101-- 01010101010101010101010101010101010101010101010101Marc P. Lavergne [wk:407-648-6996]Product DevelopmentrichLAVA Corporation--"Anyone who slaps a 'this page is best viewed withBrowser X' label on a Web page appears to beyearning for the bad old days, before the Web,when you had very little chance of reading adocument written on another computer, another wordprocessor, 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 --01010101010101010101010101010101010101010101010101Marc P. Lavergne [wk:407-648-6996]Product DevelopmentrichLAVA Corporation--"Anyone who slaps a 'this page is best viewed withBrowser X' label on a Web page appears to beyearning for the bad old days, before the Web,when you had very little chance of reading adocument written on another computer, another wordprocessor, or another network."-Tim Berners-Lee (Technology Review, July 1996)01010101010101010101010101010101010101010101010101-- 01010101010101010101010101010101010101010101010101Marc P. Lavergne [wk:407-648-6996]Product DevelopmentrichLAVA Corporation--"Anyone who slaps a 'this page is best viewed withBrowser X' label on a Web page appears to beyearning for the bad old days, before the Web,when you had very little chance of reading adocument written on another computer, another wordprocessor, or another network."-Tim Berners-Lee (Technology Review, July 1996) Marc Lavergne (06:47)
- [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 (07:08)
- BLOB support is broken in the 7.2/7.3 JDBC driver, works in 7.1 driver Marc Lavergne (07:12)
- Bug #587: Postgresql will not build on HP-UX 11.0 in debug mode pgsql-bugs (21:09)
- Re: Bug #587: Postgresql will not build on HP-UX 11.0 in Peter Eisentraut (21:46)
- Re: Bug #587: Postgresql will not build on HP-UX 11.0 in debug mode Tom Lane (22:07)
- Bug #588: Postgresql will not build on AIX; cannot locate tcl library pgsql-bugs (22:10)
2002-02-14
- bugs Srinivasa R Chava (15:19)
2002-02-15
- Bug in Postrgresql 7.2 migrating from 7.1.3 Ruud van den Brink (11:45)
- (JDBC) KEY_SEQ in Foreign Key result set starts at 0, should be 1 David Goodenough (11:46)
- Bug #589: JDBC KEY_SEQ in getImportedKey starts at 0 pgsql-bugs (11:51)
- Bug #590: Migration to Postgres 7.2 impossible when capitals are used in database name pgsql-bugs (12:06)
- Bug with SQL-COPY in 7.2 Detlef Plotzky (14:07)
- Re: Bug #590: Migration to Postgres 7.2 impossible when capitals are used in database name Tom Lane (15:21)
- Compiling error Torres Abarca Jaime (16:40)
- rename column and trigger on column Chris Sutton (17:42)
- Postgres 7.1 problem Ed Erdman (20:19)
- Possible Bug Chuck Handshy (22:23)
2002-02-16
- psqlODBC Marc Breneiser (16:24)
- Bug #591: Postgres apparently not identifying users created in Caps pgsql-bugs (18:22)
- Re: Bug #591: Postgres apparently not identifying users created in Caps Tom Lane (18:47)
2002-02-17
- crash on cash_words('21,474,836.48'::money) Eugene Pervago (21:45)
2002-02-18
- Bug #592: postgresql-odbc-7.2-1PGDG.i386.rpm lacks the actual shared library pgsql-bugs (11:35)
- Bug #593: postgresql-odbc-7.2-1PGDG.i386.rpm lacks the actual shared library pgsql-bugs (11:41)
- Bug #594: postgresql-odbc-7.2-1PGDG.i386.rpm lacks the actual shared library pgsql-bugs (11:51)
- Bug #595: No connection with jdbc since update to 7.2 pgsql-bugs (13:30)
- Re: Initdb Hangs Tom Lane (17:39)
- ecpg did not precompile declare cursor Bernhard Rckerl (21:32)
- 7.2 contrib RPM broken Greg Johnson (22:09)
2002-02-19
- Postgresql 7.1.3 not thread safe Alain Picard (01:35)
- Postgresql 7.1.3 not thread safe Alain Picard (06:02)
- Dates and year 2000 Andy Marden (18:41)
- Re: bugs Tom Lane (20:22)
- Re: Compiling error Tom Lane (20:24)
- Re: Possible Bug Tom Lane (20:33)
- Re: Postgresql 7.1.3 not thread safe Tom Lane (21:36)
- Re: crash on cash_words('21,474,836.48'::money) Tom Lane (22:21)
- Bug #596: bind to 127.0.0.1 in pgstat.c in secure server pgsql-bugs (22:36)
2002-02-20
- Re: Postgresql 7.1.3 not thread safe Alain Picard (00:43)
- Bug #597: ResultSet.next() throws NullPointerException pgsql-bugs (01:20)
- ecpg did not precompile declare cursor Lee Kindness (09:21)
- Re: Dates and year 2000 Andy Marden (20:37)
- schema error upgrading from 7.1 to 7.2 Vivek Khera (21:00)
- Bug #598: optimizer: convert 'IN' to join pgsql-bugs (21:29)
- Re: [GENERAL] schema error upgrading from 7.1 to 7.2 Tom Lane (21:31)
- Re: [GENERAL] schema error upgrading from 7.1 to 7.2 Vivek Khera (21:41)
- Re: [GENERAL] schema error upgrading from 7.1 to 7.2 Tom Lane (23:18)
- Re: Dates and year 2000 Tom Lane (23:21)
- Trying Cygwin version of PostgreSQL Peter (23:51)
2002-02-21
- Re: Dates and year 2000 Thomas Lockhart (01:54)
- Re: Trying Cygwin version of PostgreSQL Tom Lane (03:23)
- (plpgsql) DECLARE foo NUMERIC(5,2): syntax error at "(" Angus Lees (03:34)
- Re: Dates and year 2000 Andy Marden (07:59)
- Re: Dates and year 2000 Andy Marden (09:27)
- Full bug list Andy Marden (09:32)
- [No subject] Hardeep (10:24)
- Re: Trying Cygwin version of PostgreSQL Paul Rowland (12:37)
- Re: Dates and year 2000 Thomas Lockhart (14:13)
- Re: [GENERAL] schema error upgrading from 7.1 to 7.2 Vivek Khera (14:36)
2002-02-22
- Re: (plpgsql) DECLARE foo NUMERIC(5,2): syntax error at "(" Tom Lane (00:07)
- Now trying Cygwin with normal download of PostgreSQL Peter (02:37)
- Re: Full bug list Justin (03:24)
- Re: Trying Cygwin version of PostgreSQL Justin Clift (03:41)
- Re: PostgresSQL 7.1.3 not parsing SELECT portion of SQL correctly Bruce Momjian (03:56)
- Bug #599: ecpg does not parse correctly define and struct in the same file pgsql-bugs (05:23)
- Trying Cygwin version of PostgreSQL again Peter (05:44)
- Re: Bug #597: ResultSet.next() throws NullPointerException Bruce Momjian (05:44)
- Re: Trying Cygwin version of PostgreSQL again Justin Clift (06:04)
- my pl/pgsql functions return weird results Olivier Garcia (08:07)
- Bug #600: how to run the Postgres postmaster with -i flag pgsql-bugs (08:24)
- Patch pgsql-7.2 AuthBlockSig Heiko Lehmann (10:45)
- Re: Full bug list Andy Marden (12:17)
- CURRENT_TIMESTAMP not work correctly insinde a transaction. Nicolas Paymal (13:38)
- Re: my pl/pgsql functions return weird results Tom Lane (15:10)
- Re: Now trying Cygwin with normal download of PostgreSQL Tom Lane (15:29)
- Re: Patch pgsql-7.2 AuthBlockSig Bruce Momjian (15:38)
- Re: Patch pgsql-7.2 AuthBlockSig Tom Lane (15:59)
- Re: CURRENT_TIMESTAMP not work correctly insinde a transaction. Thomas Lockhart (18:42)
- Re: CURRENT_TIMESTAMP not work correctly insinde a transaction. Peter Eisentraut (22:04)
- Possible bug concerning LASTOID in 7.2 Coax (22:47)
- Bug #601: libpq needs a lo_truncate() or INV_TRUNC pgsql-bugs (23:07)
2002-02-23
- Re: CURRENT_TIMESTAMP not work correctly insinde a transaction. Tom Lane (00:36)
- Re: Bug #534: factorial function Bruce Momjian (01:06)
- Re: COPY when 'filename' is a directory Bruce Momjian (02:10)
- Re: Bug #597: ResultSet.next() throws NullPointerException Bruce Momjian (02:38)
- Re: COPY when 'filename' is a directory Bruce Momjian (21:45)
2002-02-24
- Re: COPY when 'filename' is a directory Tom Lane (01:27)
- Re: COPY when 'filename' is a directory Brent Verner (01:56)
- Re: COPY when 'filename' is a directory Brent Verner (01:59)
- Re: [PATCHES] COPY when 'filename' is a directory Bruce Momjian (02:03)
- Re: [PATCHES] COPY when 'filename' is a directory Tom Lane (02:11)
- Re: [PATCHES] COPY when 'filename' is a directory Bruce Momjian (02:31)
- Re: [PATCHES] COPY when 'filename' is a directory Tom Lane (02:41)
- Re: [PATCHES] COPY when 'filename' is a directory Bruce Momjian (02:47)
- Re: [PATCHES] COPY when 'filename' is a directory Tom Lane (03:19)
2002-02-25
- missing foreign key fails silently using COPY Lee Harr (00:58)
- Bug #602: Chinese characters query bug. pgsql-bugs (01:48)
- Re: Bug #602: Chinese characters query bug. Tatsuo Ishii (01:54)
- Re: [BUGS] Bug #602: Chinese characters query bug. Tatsuo Ishii (13:47)
- Re: missing foreign key fails silently using COPY Tom Lane (17:24)
- Re: missing foreign key fails silently using COPY Tom Lane (18:55)
- Re: Possible bug concerning LASTOID in 7.2 Tom Lane (23:29)
2002-02-26
- Re: Full bug list Justin (03:58)
- Re: Trying Cygwin version of PostgreSQL again Justin (04:05)
- COPY FROM is not 8bit clean Darcy Buskermolen (04:21)
- COPY FROM is not 8bit clean Darcy Buskermolen (04:37)
- COPY FROM is not 8bit clean Darcy Buskermolen (04:45)
- Re: COPY FROM is not 8bit clean Tom Lane (04:57)
- problems with configure connected with readline&history toxic (10:40)
- Re: COPY FROM is not 8bit clean Tatsuo Ishii (12:16)
- Bug #603: time() problems with PostgreSQL 7.2 pgsql-bugs (13:43)
- Bug #604: string join problem pgsql-bugs (13:50)
- Re: Bug #603: time() problems with PostgreSQL 7.2 Tom Lane (15:28)
- Re: Bug #604: string join problem Tom Lane (15:35)
- Re: JDBC/JSP: Strange Problem Josh Burdick (16:21)
- Re: COPY FROM is not 8bit clean Darcy Buskermolen (16:23)
- Re: COPY FROM is not 8bit clean Darcy Buskermolen (16:30)
- Re: Bug #604: string join problem Erol Ozcan (16:36)
- Re: COPY FROM is not 8bit clean Tom Lane (17:48)
- Re: COPY FROM is not 8bit clean Bruce Momjian (18:05)
- Re: COPY FROM is not 8bit clean Tom Lane (23:33)
2002-02-27
- Re: COPY FROM is not 8bit clean Bruce Momjian (03:09)
- function tree_level(varchar) (from OpenACS) no longer work under 7.2 Jean-Paul ARGUDO (08:07)
- SELECT statement causing terminating the backend Radek Hrabčák (11:16)
- cannot install postgresql 7.2 UltraMax (14:03)