pgsql-bugs since 2002-01-24 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

Jan. 24, 2002

Thread Author Time
Error Restoring Large Database Mark Rae 10:12
Bug #567: no way of restricting creation of tables pgsql-bugs 12:26
Re: Error Restoring Large Database 📎 Tom Lane 15:34
Problems with my server... Paulo Jorge Gomes Ferreira 16:41
Re: Problems with my server... Tom Lane 17:23
Bug #568: RULE ON SELECT with old values. pgsql-bugs 17:45
Re: Bug #568: RULE ON SELECT with old values. Tom Lane 18:28
Bug(?) around 'infinity' Fduch the Pravking 20:19
Re: Bug(?) around 'infinity' Tom Lane 20:27

Jan. 25, 2002

Thread Author Time
Re: COPY when 'filename' is a directory Bruce Momjian 02:04
Re: libpq not reentrant Bruce Momjian 02:20
Re: libpq not reentrant Bruce Momjian 02:20
Re: Error Restoring Large Database Mark Rae 10:44
Re: Error Restoring Large Database Tom Lane 14:54
no data for locks Chris Humphries 16:29

Jan. 26, 2002

Thread Author Time
psql in 7.2devel loops John Summerfield 11:13
initdb problems Michaele Holtman 13:36
Re: no data for locks Bruce Momjian 23:09

Jan. 28, 2002

Thread Author Time
optimizer fails to find indexes Corey Huinker 19:09

Jan. 29, 2002

Thread Author Time
plpgsql support Nagasubramanya L 04:52
postgresql-7.2b3+jdbc+DatabaseMetaData Raimund Jakobsmeyer 13:29
Bug to restore OID with pg_restore 16:57
Queries Errors Carlos Atencio 22:43
Bug #569: Strange Queries Behaviours pgsql-bugs 23:20
Re: Bug #569: Strange Queries Behaviours Stephan Szabo 23:37

Jan. 30, 2002

Thread Author Time
PostgresSQL 7.1.3 not parsing SELECT portion of SQL correctly Mark Jeacocke 22:54

Jan. 31, 2002

Thread Author Time
date format problem Yan Bai 04:49
Re: date format problem Tom Lane 05:11
New to Postgresql - Backend timeout /JDBC Peter V. Cooper 15:37
Dates and daylight saving time Fduch the Pravking 16:03
Re: Dates and daylight saving time Tom Pfau 16:44
Re: New to Postgresql - Backend timeout /JDBC Tom Lane 16:55
array_dims function is poorly behaved Marc Lavergne 17:12
Re: Dates and daylight saving time Fduch the Pravking 17:33
Re: New to Postgresql - Backend timeout /JDBC Peter V. Cooper 17:40
Re: New to Postgresql - Backend timeout /JDBC Tom Lane 17:57
Re: Dates and daylight saving time Tom Lane 18:00
Re: Dates and daylight saving time Thomas Lockhart 18:06
Re: Dates and daylight saving time Tom Lane 18:48
Re: date format problem Annie Bai 19:11
cant activate the database ? Shay 21:14
Sun Solaris 2.5.1 Seg Faults PostgreSQL7.1.3 build commands Riendeau, Mike 23:02
Re: Sun Solaris 2.5.1 Seg Faults PostgreSQL7.1.3 build commands Tom Lane 23:23

Feb. 1, 2002

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

Feb. 2, 2002

Thread Author Time
JDBC- SQLException results returned? Eric Scroger 01:08

Feb. 3, 2002

Thread Author Time
Bug #571: Impossible to completly support JDBC pgsql-bugs 19:24

Feb. 4, 2002

Thread Author Time
Bug #572: Double Format pgsql-bugs 06:36
Re: Bug #572: Double Format Peter Eisentraut 16:12

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

Browse Archives

Prev | Next