Home > mailing lists

Mailing lists [pgsql-bugs]

1 February 2002

02:14 Re: date format problem Thomas Lockhart
07:15 strange bug with vacuum hubert depesz lubaczewski
09:15 Re: New to Postgresql - Backend timeout /JDBC Stefano Reksten
11:56 Bug #570: \d in psql does not show triggers pgsql-bugs@postgresql.org
12:55 Re: Bug #570: \d in psql does not show triggers Tom Lane
14:45 Re: strange bug with vacuum Stephan Szabo
16:15 Re: New to Postgresql - Backend timeout /JDBC Peter V. Cooper
16:45 postgresql-7.2b3+jdbc+DatabaseMetaData 520003909361-0001@t-online.de (Raimund Jakobsmeyer)
16:45 Bug to restore OID with pg_restore abremond@voila.fr
16:45 psql in 7.2devel loops John Summerfield
16:45 plpgsql support Nagasubramanya L
16:45 optimizer fails to find indexes Corey Huinker
16:45 Queries Errors Carlos Atencio
16:46 initdb problems Michaele Holtman
17:05 PostgresSQL 7.1.3 not parsing SELECT portion of SQL correctly Mark Jeacocke
17:06 Re: Bug to restore OID with pg_restore Bruce Momjian
17:06 array_dims function is poorly behaved Marc Lavergne
17:15 Re: plpgsql support Stephan Szabo
17:15 cant activate the database ? Shay
17:37 Re: initdb problems Grant Johnson
17:45 Re: psql in 7.2devel loops Tom Lane
17:55 Re: Queries Errors Tom Lane
18:08 Re: initdb problems Tom Lane
19:15 Re: Sun Solaris 2.5.1 Seg Faults PostgreSQL7.1.3 build com mands Tom Lane
19:15 Re: Sun Solaris 2.5.1 Seg Faults PostgreSQL7.1.3 build com Riendeau, Mike
20:15 Re: array_dims function is poorly behaved Tom Lane
20:56 Re: PostgresSQL 7.1.3 not parsing SELECT portion of SQL correctly Tom Lane
23:15 JDBC- SQLException results returned? Eric Scroger

3 February 2002

17:36 Bug #571: Impossible to completly support JDBC pgsql-bugs@postgresql.org

4 February 2002

04:46 Bug #572: Double Format pgsql-bugs@postgresql.org
14:17 Re: Bug #572: Double Format Peter Eisentraut

5 February 2002

12:51 resource leak in 7.2 Tom Pfau
14:17 Bug #573: fails to make darwin 5.2 pgsql-bugs@postgresql.org
14:27 Re: resource leak in 7.2 Tom Lane
14:46 Re: Bug #573: fails to make darwin 5.2 Tom Lane
14:57 Re: [CYGWIN] resource leak in 7.2 Henshall, Stuart - WCP
15:25 Re: [CYGWIN] resource leak in 7.2 Tom Lane
15:27 Re: [CYGWIN] resource leak in 7.2 Tom Pfau
15:27 Re: resource leak in 7.2 Tom Pfau
15:37 index and timestamp column Thomas Zehetbauer
16:17 Re: resource leak in 7.2 Tom Lane

6 February 2002

03:10 Re: [CYGWIN] resource leak in 7.2 Tom Pfau
22:09 Bug #574: can not create tables that start with "Clinic" pgsql-bugs@postgresql.org
22:19 Re: Bug #574: can not create tables that start with "Clinic" Peter Eisentraut
22:39 Re: Bug #574: can not create tables that start with "Clinic" Edwin Grubbs

7 February 2002

13:22 Bug #575: Build Problem with Postgresql 7.1.3 on Aix 4.3.3 with VisualAge 5.0 compiler resources: pgsql-bugs@postgresql.org
15:50 Re: Bug #575: Build Problem with Postgresql 7.1.3 on Aix 4.3.3 with VisualAge 5.0 compiler resources: Tom Lane

8 February 2002

02:40 Bug #576: Can not compile IRIX + GCC pgsql-bugs@postgresql.org
03:20 Re: Bug #576: Can not compile IRIX + GCC Bruce Momjian
05:32 Bug #577: incorect sort using order by pgsql-bugs@postgresql.org
07:52 Re: Bug #576: Can not compile IRIX + GCC Luis Amigo
14:25 Re: Bug #577: incorect sort using order by Tom Lane
16:28 Re: [CYGWIN] resource leak in 7.2 Hiroshi Inoue
17:22 Bug #578: pg_dumpall from 7.1.3 can not be imported in 7.2.0 pgsql-bugs@postgresql.org
17:42 Re: Bug #578: pg_dumpall from 7.1.3 can not be imported in Stephan Szabo

9 February 2002

05:00 Re: Bug #578: pg_dumpall from 7.1.3 can not be imported in Rainer Tammer

10 February 2002

21:50 Re: Bug #578: pg_dumpall from 7.1.3 can not be imported in 7.2.0 Tom Lane

11 February 2002

05:50 Bug #579: Auto-VACUUM doesnt work pgsql-bugs@postgresql.org
14:22 Re: Bug #579: Auto-VACUUM doesnt work Tom Lane
14:23 Re: Bug #579: Auto-VACUUM doesnt work Peter Eisentraut
17:52 Re: Bug #578: pg_dumpall from 7.1.3 can not be imported in 7.2.0 Tom Lane
21:12 Bug #580: Optimizer uses seq scan only pgsql-bugs@postgresql.org
21:52 Re: Bug #580: Optimizer uses seq scan only Stephan Szabo
21:52 Re: Bug #580: Optimizer uses seq scan only Tom Lane
23:42 Bug #581: Sequence cannot be deleted pgsql-bugs@postgresql.org
23:42 Bug #582: no mapping for java.sql.Types.DECIMAL pgsql-bugs@postgresql.org

12 February 2002

00:21 Re: Bug #581: Sequence cannot be deleted Tom Lane
00:21 Re: Bug #581: Sequence cannot be deleted Stephan Szabo
17:27 Bug #583: Wrong example in 7.2 Tutorial pgsql-bugs@postgresql.org
17:43 Bug #584: postgresql will not build on Solaris with cc pgsql-bugs@postgresql.org
17:54 Bug #584: postgresql will not build on Solaris with cc pgsql-bugs@postgresql.org
18:02 Bug #584: postgresql will not build on Solaris with cc pgsql-bugs@postgresql.org
19:21 Re: Bug #584: postgresql will not build on Solaris with cc Tom Lane
20:21 Re: Bug #584: postgresql will not build on Solaris with cc Nishad Prakash
20:48 Re: Bug #583: Wrong example in 7.2 Tutorial Bruce Momjian

13 February 2002

19:21 Bug #587: Postgresql will not build on HP-UX 11.0 in debug mode pgsql-bugs@postgresql.org
19:52 Re: Bug #587: Postgresql will not build on HP-UX 11.0 in Peter Eisentraut
20:12 Bug #588: Postgresql will not build on AIX; cannot locate tcl library pgsql-bugs@postgresql.org
20:22 Re: Bug #587: Postgresql will not build on HP-UX 11.0 in debug mode Tom Lane

15 February 2002

09:54 Bug #589: JDBC KEY_SEQ in getImportedKey starts at 0 pgsql-bugs@postgresql.org
10:22 Bug #590: Migration to Postgres 7.2 impossible when capitals are used in database name pgsql-bugs@postgresql.org
13:34 Re: Bug #590: Migration to Postgres 7.2 impossible when capitals are used in database name Tom Lane

16 February 2002

16:22 Bug #591: Postgres apparently not identifying users created in Caps pgsql-bugs@postgresql.org
16:52 Re: Bug #591: Postgres apparently not identifying users created in Caps Tom Lane

18 February 2002

19 February 2002

03:52 Postgresql 7.1.3 not thread safe Alain Picard
17:15 bugs Srinivasa R Chava
17:15 Bug in Postrgresql 7.2 migrating from 7.1.3 Ruud van den Brink
17:15 (JDBC) KEY_SEQ in Foreign Key result set starts at 0, should be 1 David Goodenough
17:15 Bug with SQL-COPY in 7.2 Detlef Plotzky
17:15 [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
17:15 createdb problem Isamary García
17:15 rename column and trigger on column Chris Sutton
17:24 Postgres 7.1 problem Ed Erdman
17:24 Compiling error Torres Abarca Jaime
17:25 BLOB support is broken in the 7.2/7.3 JDBC driver, works in 7.1 driver Marc Lavergne
18:24 Possible Bug Chuck Handshy
18:24 Re: bugs Tom Lane
18:24 psqlODBC mbreneiser@whgrp.com (Marc Breneiser)
18:35 Postgresql 7.1.3 not thread safe Alain Picard
18:35 7.2 contrib RPM broken Greg Johnson
18:35 ecpg did not precompile declare cursor Bernhard Rückerl
18:35 Re: Compiling error Tom Lane
18:45 crash on cash_words('21,474,836.48'::money) Eugene Pervago
18:45 Re: Possible Bug Tom Lane
19:53 Re: Postgresql 7.1.3 not thread safe Tom Lane
20:24 Re: crash on cash_words('21,474,836.48'::money) Tom Lane
20:45 Bug #596: bind to 127.0.0.1 in pgstat.c in secure server pgsql-bugs@postgresql.org
22:45 Re: Postgresql 7.1.3 not thread safe Alain Picard
23:24 Bug #597: ResultSet.next() throws NullPointerException pgsql-bugs@postgresql.org

20 February 2002

07:48 ecpg did not precompile declare cursor Lee Kindness
19:39 Bug #598: optimizer: convert 'IN' to join pgsql-bugs@postgresql.org
19:39 Re: Dates and year 2000 Andy Marden
19:41 Re: [GENERAL] schema error upgrading from 7.1 to 7.2 Tom Lane
21:40 Re: Dates and year 2000 Tom Lane
21:41 Re: [GENERAL] schema error upgrading from 7.1 to 7.2 Tom Lane
23:13 schema error upgrading from 7.1 to 7.2 Vivek Khera
23:14 Re: [GENERAL] schema error upgrading from 7.1 to 7.2 Vivek Khera
23:14 Trying Cygwin version of PostgreSQL Peter
23:56 Re: Dates and year 2000 Thomas Lockhart

21 February 2002

01:24 Re: Trying Cygwin version of PostgreSQL Tom Lane
06:04 Re: Dates and year 2000 Andy Marden
07:41 Re: Dates and year 2000 Andy Marden
08:07 Full bug list Andy Marden
10:37 Re: Trying Cygwin version of PostgreSQL Paul Rowland
12:15 Re: Dates and year 2000 Thomas Lockhart
17:36 Re: [GENERAL] schema error upgrading from 7.1 to 7.2 Vivek Khera
17:44 Hardeep
18:33 (plpgsql) DECLARE foo NUMERIC(5,2): syntax error at "(" Angus Lees
22:09 Re: (plpgsql) DECLARE foo NUMERIC(5,2): syntax error at "(" Tom Lane

22 February 2002

01:32 Re: Full bug list Justin
01:50 Re: Trying Cygwin version of PostgreSQL Justin Clift
01:57 Re: PostgresSQL 7.1.3 not parsing SELECT portion of SQL correctly Bruce Momjian
03:23 Bug #599: ecpg does not parse correctly define and struct in the same file pgsql-bugs@postgresql.org
03:45 Re: Bug #597: ResultSet.next() throws NullPointerException Bruce Momjian
04:13 Re: Trying Cygwin version of PostgreSQL again Justin Clift
06:18 my pl/pgsql functions return weird results Olivier Garcia
06:24 Bug #600: how to run the Postgres postmaster with -i flag pgsql-bugs@postgresql.org
10:22 Re: Full bug list Andy Marden
11:33 Now trying Cygwin with normal download of PostgreSQL Peter
11:38 Trying Cygwin version of PostgreSQL again Peter
11:42 Patch pgsql-7.2 AuthBlockSig Heiko Lehmann
13:11 Re: my pl/pgsql functions return weird results Tom Lane
13:33 Re: Now trying Cygwin with normal download of PostgreSQL Tom Lane
13:40 Re: Patch pgsql-7.2 AuthBlockSig Bruce Momjian
14:25 Re: Patch pgsql-7.2 AuthBlockSig Tom Lane
16:23 CURRENT_TIMESTAMP not work correctly insinde a transaction. Nicolas Paymal
16:47 Re: CURRENT_TIMESTAMP not work correctly insinde a transaction. Thomas Lockhart
20:02 Re: CURRENT_TIMESTAMP not work correctly insinde a transaction. Peter Eisentraut
20:47 Possible bug concerning LASTOID in 7.2 Coax
21:08 Bug #601: libpq needs a lo_truncate() or INV_TRUNC pgsql-bugs@postgresql.org
22:37 Re: CURRENT_TIMESTAMP not work correctly insinde a transaction. Tom Lane
23:06 Re: Bug #534: factorial function Bruce Momjian

23 February 2002

00:10 Re: COPY when 'filename' is a directory Bruce Momjian
00:38 Re: Bug #597: ResultSet.next() throws NullPointerException Bruce Momjian
19:46 Re: COPY when 'filename' is a directory Bruce Momjian
23:28 Re: COPY when 'filename' is a directory Tom Lane
23:56 Re: COPY when 'filename' is a directory Brent Verner

24 February 2002

00:00 Re: COPY when 'filename' is a directory Brent Verner
00:03 Re: [PATCHES] COPY when 'filename' is a directory Bruce Momjian
00:11 Re: [PATCHES] COPY when 'filename' is a directory Tom Lane
00:31 Re: [PATCHES] COPY when 'filename' is a directory Bruce Momjian
00:41 Re: [PATCHES] COPY when 'filename' is a directory Tom Lane
00:47 Re: [PATCHES] COPY when 'filename' is a directory Bruce Momjian
01:20 Re: [PATCHES] COPY when 'filename' is a directory Tom Lane
23:48 Bug #602: Chinese characters query bug. pgsql-bugs@postgresql.org
23:55 Re: Bug #602: Chinese characters query bug. Tatsuo Ishii

25 February 2002

12:08 missing foreign key fails silently using COPY missive@frontiernet.net (Lee Harr)
16:18 Re: missing foreign key fails silently using COPY Tom Lane
16:58 Re: missing foreign key fails silently using COPY Tom Lane
21:29 Re: Possible bug concerning LASTOID in 7.2 Tom Lane

26 February 2002

02:06 Re: Full bug list Justin
02:13 Re: Trying Cygwin version of PostgreSQL again Justin
02:19 COPY FROM is not 8bit clean Darcy Buskermolen
02:34 COPY FROM is not 8bit clean Darcy Buskermolen
02:42 COPY FROM is not 8bit clean Darcy Buskermolen
02:58 Re: COPY FROM is not 8bit clean Tom Lane
10:19 Re: COPY FROM is not 8bit clean Tatsuo Ishii
11:44 Bug #603: time() problems with PostgreSQL 7.2 pgsql-bugs@postgresql.org
11:50 Bug #604: string join problem pgsql-bugs@postgresql.org
13:31 Re: Bug #603: time() problems with PostgreSQL 7.2 Tom Lane
13:35 Re: Bug #604: string join problem Tom Lane
14:21 Re: COPY FROM is not 8bit clean Darcy Buskermolen
14:28 Re: COPY FROM is not 8bit clean Darcy Buskermolen
15:56 Re: COPY FROM is not 8bit clean Tom Lane
16:21 Re: COPY FROM is not 8bit clean Bruce Momjian
16:52 Re: JDBC/JSP: Strange Problem Josh Burdick
16:53 problems with configure connected with readline&history toxic
17:06 Re: Bug #604: string join problem Erol Ozcan
21:34 Re: COPY FROM is not 8bit clean Tom Lane

27 February 2002

01:10 Re: COPY FROM is not 8bit clean Bruce Momjian
06:08 function tree_level(varchar) (from OpenACS) no longer work under 7.2 Jean-Paul ARGUDO
14:51 Re: function tree_level(varchar) (from OpenACS) no longer work under 7.2 Jean-Paul ARGUDO
15:03 performance problems on updates on large tables with indexes Reinhard Max
15:08 Re: function tree_level(varchar) (from OpenACS) no longer work under 7.2 Tom Lane
20:14 Re: performance problems on updates on large tables with indexes Tom Lane
21:04 Re: missing foreign key fails silently using COPY Tom Lane

28 February 2002

00:55 Indexes not always used after inserts/updates/vacuum analyze Michael G. Martin
01:57 Re: Indexes not always used after inserts/updates/vacuum analyze Tom Lane
02:16 Re: Indexes not always used after inserts/updates/vacuum analyze Michael G. Martin
02:28 Re: Indexes not always used after inserts/updates/vacuum analyze Tom Lane
02:33 Re: Indexes not always used after inserts/updates/vacuum analyze Michael G. Martin
02:40 Re: Indexes not always used after inserts/updates/vacuum analyze Tom Lane
02:41 Re: Indexes not always used after inserts/updates/vacuum analyze Michael G. Martin
02:45 Re: Indexes not always used after inserts/updates/vacuum analyze Michael G. Martin
03:01 Re: Indexes not always used after inserts/updates/vacuum analyze Tom Lane
03:20 Re: Indexes not always used after inserts/updates/vacuum analyze Michael G. Martin
09:57 Re: Indexes not always used after inserts/updates/vacuum Reinhard Max
12:43 Re: Indexes not always used after inserts/updates/vacuum analyze Michael G. Martin
13:53 Re: Indexes not always used after inserts/updates/vacuum Reinhard Max
13:55 Re: Indexes not always used after inserts/updates/vacuum analyze Tom Lane
14:24 Re: Indexes not always used after inserts/updates/vacuum analyze Tom Lane
15:03 Re: Indexes not always used after inserts/updates/vacuum Reinhard Max
19:13 Re: Indexes not always used after inserts/updates/vacuum analyze Tom Lane