pgsql-bugs since 2002-02-05 00:00

If you find a bug, please use the bug reporting form.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

Feb. 5, 2002

Thread Author Time
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

Feb. 7, 2002

Thread Author Time
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

Feb. 8, 2002

Thread Author Time
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

Feb. 9, 2002

Thread Author Time
Re: Bug #578: pg_dumpall from 7.1.3 can not be imported in Rainer Tammer 06:58

Feb. 10, 2002

Thread Author Time
Re: Bug #578: pg_dumpall from 7.1.3 can not be imported in 7.2.0 Tom Lane 23:48

Feb. 11, 2002

Thread Author Time
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

Feb. 12, 2002

Thread Author Time
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

Feb. 13, 2002

Thread Author Time
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 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

Feb. 14, 2002

Thread Author Time
bugs Srinivasa R Chava 15:19

Feb. 15, 2002

Thread Author Time
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

Feb. 16, 2002

Thread Author Time
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

Feb. 17, 2002

Thread Author Time
crash on cash_words('21,474,836.48'::money) Eugene Pervago 21:45

Feb. 18, 2002

Thread Author Time
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

Feb. 19, 2002

Thread Author Time
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

Feb. 20, 2002

Thread Author Time
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

Feb. 21, 2002

Thread Author Time
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

Feb. 22, 2002

Thread Author Time
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

Feb. 23, 2002

Thread Author Time
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

Feb. 24, 2002

Thread Author Time
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

Feb. 25, 2002

Thread Author Time
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

Feb. 26, 2002

Thread Author Time
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

Feb. 27, 2002

Thread Author Time
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
Re: function tree_level(varchar) (from OpenACS) no longer work under 7.2 Tom Lane 15:07
performance problems on updates on large tables with indexes Reinhard Max 16:29
Re: function tree_level(varchar) (from OpenACS) no longer work under 7.2 Jean-Paul ARGUDO 16:36
Re: performance problems on updates on large tables with indexes Tom Lane 21:41
Re: missing foreign key fails silently using COPY Tom Lane 23:04
Segmentation Fault Sidney 23:06

Feb. 28, 2002

Thread Author Time
Indexes not always used after inserts/updates/vacuum analyze Michael G. Martin 02:53
Re: Indexes not always used after inserts/updates/vacuum analyze Tom Lane 03:57
Re: Indexes not always used after inserts/updates/vacuum analyze 📎 Michael G. Martin 04:15
Re: Indexes not always used after inserts/updates/vacuum analyze Tom Lane 04:28
Re: Indexes not always used after inserts/updates/vacuum analyze Michael G. Martin 04:32
Re: Indexes not always used after inserts/updates/vacuum analyze Tom Lane 04:40
Re: Indexes not always used after inserts/updates/vacuum analyze Michael G. Martin 04:41
Re: Indexes not always used after inserts/updates/vacuum analyze Michael G. Martin 04:45
Re: Indexes not always used after inserts/updates/vacuum analyze Tom Lane 05:00
Re: Indexes not always used after inserts/updates/vacuum analyze Michael G. Martin 05:20
postmaster problem.... Nitesh 06:25
Re: Indexes not always used after inserts/updates/vacuum Reinhard Max 11:56
Re: Indexes not always used after inserts/updates/vacuum analyze Michael G. Martin 14:40
Re: Indexes not always used after inserts/updates/vacuum analyze Tom Lane 14:51
Re: Indexes not always used after inserts/updates/vacuum 📎 Reinhard Max 15:00

Browse Archives

Prev | Next