Skip site navigation (1)
Skip section navigation (2)
220 messages
27 February 2002
Re: performance problems on updates on large tables with indexes Tom Lane (21:42)
Re: function tree_level(varchar) (from OpenACS) no longer work under 7.2 Jean-Paul ARGUDO (16:35)
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 Tom Lane (15:07)
function tree_level(varchar) (from OpenACS) no longer work under 7.2 Jean-Paul ARGUDO (08:07)
Re: COPY FROM is not 8bit clean Bruce Momjian (03:09)
26 February 2002
Re: COPY FROM is not 8bit clean Bruce Momjian (18:05)
Re: COPY FROM is not 8bit clean Tom Lane (17:48)
Re: COPY FROM is not 8bit clean Darcy Buskermolen (16:27)
Re: JDBC/JSP: Strange Problem Josh Burdick (16:24)
Re: Bug #604: string join problem Erol Ozcan (16:22)
Re: COPY FROM is not 8bit clean Darcy Buskermolen (16:20)
Re: Bug #604: string join problem Tom Lane (15:35)
Re: Bug #603: time() problems with PostgreSQL 7.2 Tom Lane (15:28)
Bug #604: string join problem pgsql-bugs (13:50)
Bug #603: time() problems with PostgreSQL 7.2 pgsql-bugs (13:43)
Re: COPY FROM is not 8bit clean Tatsuo Ishii (12:17)
problems with configure connected with readline&history toxic (10:41)
Re: COPY FROM is not 8bit clean Tom Lane (04:57)
COPY FROM is not 8bit clean Darcy Buskermolen (04:42)
COPY FROM is not 8bit clean Darcy Buskermolen (04:34)
COPY FROM is not 8bit clean Darcy Buskermolen (04:19)
Re: Trying Cygwin version of PostgreSQL again Justin (04:13)
Re: Full bug list Justin (04:05)
25 February 2002
Re: missing foreign key fails silently using COPY Tom Lane (18:55)
Re: missing foreign key fails silently using COPY Tom Lane (17:24)
Re: Bug #602: Chinese characters query bug. Tatsuo Ishii (01:55)
Bug #602: Chinese characters query bug. pgsql-bugs (01:48)
missing foreign key fails silently using COPY Lee Harr (01:11)
24 February 2002
Re: [PATCHES] COPY when 'filename' is a directory Bruce Momjian (02:47)
Re: [PATCHES] COPY when 'filename' is a directory Tom Lane (02:41)
Re: [PATCHES] COPY when 'filename' is a directory Bruce Momjian (02:31)
Re: [PATCHES] COPY when 'filename' is a directory Tom Lane (02:11)
Re: [PATCHES] COPY when 'filename' is a directory Bruce Momjian (02:03)
Re: COPY when 'filename' is a directory Brent Verner (02:00)
Re: COPY when 'filename' is a directory Brent Verner (01:56)
Re: COPY when 'filename' is a directory Tom Lane (01:28)
23 February 2002
Re: Bug #597: ResultSet.next() throws NullPointerException Bruce Momjian (02:38)
Re: COPY when 'filename' is a directory Bruce Momjian (02:10)
Re: Bug #534: factorial function Bruce Momjian (01:06)
Re: CURRENT_TIMESTAMP not work correctly insinde a transaction. Tom Lane (00:36)
22 February 2002
Possible bug concerning LASTOID in 7.2 Coax (22:47)
Re: CURRENT_TIMESTAMP not work correctly insinde a transaction. Peter Eisentraut (22:01)
Re: CURRENT_TIMESTAMP not work correctly insinde a transaction. Thomas Lockhart (18:42)
Re: Patch pgsql-7.2 AuthBlockSig Tom Lane (15:59)
Re: Patch pgsql-7.2 AuthBlockSig Bruce Momjian (15:38)
Re: Now trying Cygwin with normal download of PostgreSQL Tom Lane (15:29)
Re: my pl/pgsql functions return weird results Tom Lane (15:10)
CURRENT_TIMESTAMP not work correctly insinde a transaction. Nicolas Paymal (13:42)
Re: Full bug list Andy Marden (12:22)
Patch pgsql-7.2 AuthBlockSig Heiko Lehmann (10:53)
Bug #600: how to run the Postgres postmaster with -i flag pgsql-bugs (08:24)
my pl/pgsql functions return weird results Olivier Garcia (08:17)
Re: Trying Cygwin version of PostgreSQL again Justin Clift (06:12)
Re: Bug #597: ResultSet.next() throws NullPointerException Bruce Momjian (05:44)
Trying Cygwin version of PostgreSQL again Peter (05:44)
Bug #599: ecpg does not parse correctly define and struct in the same file pgsql-bugs (05:23)
Re: PostgresSQL 7.1.3 not parsing SELECT portion of SQL correctly Bruce Momjian (03:57)
Re: Trying Cygwin version of PostgreSQL Justin Clift (03:49)
Re: Full bug list Justin (03:32)
Now trying Cygwin with normal download of PostgreSQL Peter (02:37)
Re: (plpgsql) DECLARE foo NUMERIC(5,2): syntax error at "(" Tom Lane (00:08)
21 February 2002
Re: Dates and year 2000 Thomas Lockhart (14:13)
Re: Trying Cygwin version of PostgreSQL Paul Rowland (12:37)
[no subject] Hardeep (10:20)
Full bug list Andy Marden (10:06)
Re: Dates and year 2000 Andy Marden (09:40)
Re: Dates and year 2000 Andy Marden (08:03)
(plpgsql) DECLARE foo NUMERIC(5,2): syntax error at "(" Angus Lees (04:07)
Re: Trying Cygwin version of PostgreSQL Tom Lane (03:24)
Re: Dates and year 2000 Thomas Lockhart (01:54)
20 February 2002
Re: Dates and year 2000 Tom Lane (23:21)
Re: [GENERAL] schema error upgrading from 7.1 to 7.2 Tom Lane (23:18)
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 (21:31)
Bug #598: optimizer: convert 'IN' to join pgsql-bugs (21:29)
Re: Dates and year 2000 Andy Marden (21:10)
schema error upgrading from 7.1 to 7.2 Vivek Khera (21:00)
ecpg did not precompile declare cursor Lee Kindness (09:21)
Bug #597: ResultSet.next() throws NullPointerException pgsql-bugs (01:20)
Re: Postgresql 7.1.3 not thread safe Alain Picard (00:32)
19 February 2002
Re: crash on cash_words('21,474,836.48'::money) Tom Lane (22:21)
Re: Postgresql 7.1.3 not thread safe Tom Lane (21:36)
Re: Possible Bug Tom Lane (20:34)
Re: Compiling error Tom Lane (20:25)
Re: bugs Tom Lane (20:22)
Postgresql 7.1.3 not thread safe Alain Picard (05:51)
Postgresql 7.1.3 not thread safe Alain Picard (01:24)
18 February 2002
ecpg did not precompile declare cursor Bernhard Rückerl (21:54)
Re: Initdb Hangs Tom Lane (17:39)
Bug #595: No connection with jdbc since update to 7.2 pgsql-bugs (13:30)
Bug #594: postgresql-odbc-7.2-1PGDG.i386.rpm lacks the actual shared library pgsql-bugs (11:51)
Bug #593: postgresql-odbc-7.2-1PGDG.i386.rpm lacks the actual shared library pgsql-bugs (11:41)
Bug #592: postgresql-odbc-7.2-1PGDG.i386.rpm lacks the actual shared library pgsql-bugs (11:35)
17 February 2002
16 February 2002
Bug #591: Postgres apparently not identifying users created in Caps pgsql-bugs (18:22)
psqlODBC Marc Breneiser (16:30)
15 February 2002
Postgres 7.1 problem Ed Erdman (20:20)
rename column and trigger on column Chris Sutton (17:42)
Compiling error Torres Abarca Jaime (16:44)
Re: Bug #590: Migration to Postgres 7.2 impossible when capitals are used in database name Tom Lane (15:22)
Bug with SQL-COPY in 7.2 Detlef Plotzky (14:07)
Bug #590: Migration to Postgres 7.2 impossible when capitals are used in database name pgsql-bugs (12:06)
Bug #589: JDBC KEY_SEQ in getImportedKey starts at 0 pgsql-bugs (11:51)
(JDBC) KEY_SEQ in Foreign Key result set starts at 0, should be 1 David Goodenough (11:46)
Bug in Postrgresql 7.2 migrating from 7.1.3 Ruud van den Brink (11:45)
14 February 2002
13 February 2002
Re: Bug #587: Postgresql will not build on HP-UX 11.0 in debug mode Tom Lane (22:08)
Re: Bug #587: Postgresql will not build on HP-UX 11.0 in Peter Eisentraut (21:43)
Bug #587: Postgresql will not build on HP-UX 11.0 in debug mode pgsql-bugs (21:09)
BLOB support is broken in the 7.2/7.3 JDBC driver, works in 7.1 driver Marc Lavergne (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 (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 (06:46)
12 February 2002
Re: Bug #584: postgresql will not build on Solaris with cc Nishad Prakash (22:10)
Re: Bug #584: postgresql will not build on Solaris with cc Tom Lane (21:15)
createdb problem Isamary García (20:10)
Bug #584: postgresql will not build on Solaris with cc pgsql-bugs (19:54)
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:27)
Bug #583: Wrong example in 7.2 Tutorial pgsql-bugs (18:55)
Re: Bug #581: Sequence cannot be deleted Tom Lane (02:17)
Re: Bug #581: Sequence cannot be deleted Stephan Szabo (02:14)
Bug #582: no mapping for java.sql.Types.DECIMAL pgsql-bugs (01:38)
Bug #581: Sequence cannot be deleted pgsql-bugs (01:26)
Re: Initdb Hangs Blossom, Eric (00:14)
Initdb Hangs Blossom, Eric (00:05)
11 February 2002
Re: Bug #580: Optimizer uses seq scan only Tom Lane (23:22)
Bug #580: Optimizer uses seq scan only pgsql-bugs (22:51)
Re: Bug #578: pg_dumpall from 7.1.3 can not be imported in 7.2.0 Tom Lane (19:47)
Re: Bug #579: Auto-VACUUM doesnt work Peter Eisentraut (16:11)
Re: Bug #579: Auto-VACUUM doesnt work Tom Lane (16:07)
Bug #579: Auto-VACUUM doesnt work pgsql-bugs (07:47)
10 February 2002
09 February 2002
08 February 2002
Bug #578: pg_dumpall from 7.1.3 can not be imported in 7.2.0 pgsql-bugs (19:03)
Re: [CYGWIN] resource leak in 7.2 Hiroshi Inoue (18:15)
Re: Bug #577: incorect sort using order by Tom Lane (16:10)
Re: Bug #576: Can not compile IRIX + GCC Luis Amigo (09:27)
Bug #577: incorect sort using order by pgsql-bugs (07:25)
Re: Bug #576: Can not compile IRIX + GCC Bruce Momjian (04:53)
Bug #576: Can not compile IRIX + GCC pgsql-bugs (04:35)
07 February 2002
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 #574: can not create tables that start with "Clinic" Edwin Grubbs (00:24)
Re: Bug #574: can not create tables that start with "Clinic" Peter Eisentraut (00:18)
Bug #574: can not create tables that start with "Clinic" pgsql-bugs (00:00)
06 February 2002
Peripheral Links
Header And Logo
|
Site Navigation
pgsql-bugs 2002-02 Chronological Index (1/2)
Last updated: Wed Jan 18 01:47:26 2012220 messages
- Thread Index
- [Prev Page]
- [Next Page]
- 28 February 2002
- Re: Indexes not always used after inserts/updates/vacuum analyze Tom Lane (21:10)
- Re: Indexes not always used after inserts/updates/vacuum Reinhard Max (16:43)
- Re: Indexes not always used after inserts/updates/vacuum analyze Tom Lane (15:16)
- Re: Indexes not always used after inserts/updates/vacuum Reinhard Max (15:00)
- Re: Indexes not always used after inserts/updates/vacuum analyze Tom Lane (14:51)
- Re: Indexes not always used after inserts/updates/vacuum analyze Michael G. Martin (14:40)
- 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 (05:20)
- 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 (04:45)
- 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 Tom Lane (04:40)
- 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:28)
- 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 (03:57)
- Indexes not always used after inserts/updates/vacuum analyze Michael G. Martin (02:53)
- Re: missing foreign key fails silently using COPY Tom Lane (23:04)
- Re: COPY FROM is not 8bit clean Tom Lane (23:33)
- Re: Possible bug concerning LASTOID in 7.2 Tom Lane (23:29)
- Re: [PATCHES] COPY when 'filename' is a directory Tom Lane (03:19)
- Re: COPY when 'filename' is a directory Bruce Momjian (21:46)
- Bug #601: libpq needs a lo_truncate() or INV_TRUNC pgsql-bugs (23:07)
- Re: [GENERAL] schema error upgrading from 7.1 to 7.2 Vivek Khera (14:36)
- Trying Cygwin version of PostgreSQL Peter (23:51)
- Bug #596: bind to 127.0.0.1 in pgstat.c in secure server pgsql-bugs (22:36)
- 7.2 contrib RPM broken Greg Johnson (22:09)
- crash on cash_words('21,474,836.48'::money) Eugene Pervago (21:45)
- Possible Bug Chuck Handshy (22:25)
- bugs Srinivasa R Chava (15:16)
- Bug #588: Postgresql will not build on AIX; cannot locate tcl library pgsql-bugs (22:10)
- Re: Bug #583: Wrong example in 7.2 Tutorial Bruce Momjian (22:26)
- Re: Bug #580: Optimizer uses seq scan only Stephan Szabo (23:44)
- Re: Bug #578: pg_dumpall from 7.1.3 can not be imported in 7.2.0 Tom Lane (23:50)
- Re: Bug #578: pg_dumpall from 7.1.3 can not be imported in Rainer Tammer (06:59)
- Re: Bug #578: pg_dumpall from 7.1.3 can not be imported in Stephan Szabo (19:34)
- Re: [CYGWIN] resource leak in 7.2 Tom Pfau (05:00)
- Thread Index
- [Prev Page]
- [Next Page]