Re: [BUGS] Huge query stalls at PARSE/BIND stage (1)

2005-11-21 Thread Matt
Thanks for the test case. The problem turns out to be sloppy coding in exprTypmod(): it recurses twice on the first argument of a COALESCE, making for exponential growth in the time needed to process a deep nest of COALESCE expressions ... which is exactly what your deeply nested FULL JOINs

[BUGS] BUG #2059: PGConnect fails when used in a thread

2005-11-21 Thread Chris Storah
The following bug has been logged online: Bug reference: 2059 Logged by: Chris Storah Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.3 Operating system: Linux - Fedora Core 4 x86_64 version Description:PGConnect fails when used in a thread Details:

[BUGS] BUG #2060: Issue with Data base connection

2005-11-21 Thread Manideep Kalisetty
The following bug has been logged online: Bug reference: 2060 Logged by: Manideep Kalisetty Email address: [EMAIL PROTECTED] PostgreSQL version: 7.2.2 Operating system: Windows and Linux Description:Issue with Data base connection Details: I am using

[BUGS] BUG #2058: Wrong Greek ISO-encoding assignment

2005-11-21 Thread Mantelos Dimitrios
The following bug has been logged online: Bug reference: 2058 Logged by: Mantelos Dimitrios Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0.2 Operating system: Windows XP Pro Linux Gentoo 2.6.13 Description:Wrong Greek ISO-encoding assignment Details:

[BUGS] BUG #2061: pg_dumpall -f not supported

2005-11-21 Thread Florian Steinel
The following bug has been logged online: Bug reference: 2061 Logged by: Florian Steinel Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0 Operating system: Gentoo 2005.1 Description:pg_dumpall -f not supported Details: pg_dump supports the f option but

[BUGS] strange disappearence of postgres file

2005-11-21 Thread Harald Armin Massa
I ran into a very strange disappearance of a postgresql data file.The environment:Windows XP professionalselect version();PostgreSQL 8.0.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)All datafiles are within c:\ghum\datathat part of the harddrive is only accessable to

Re: [BUGS] BUG #2059: PGConnect fails when used in a thread

2005-11-21 Thread Tom Lane
Chris Storah [EMAIL PROTECTED] writes: fe-connect.c - parseServiceInfo is failing because no service option is being used in the connection string so service is NULL. The line that fails is the 'snprintf(serviceFile, MAXPGPATH, %s/pg_service.conf, ...) line. Huh? That statement doesn't use

[BUGS] BUG #2062: Timezone unrecognised

2005-11-21 Thread David Begley
The following bug has been logged online: Bug reference: 2062 Logged by: David Begley Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Windows Description:Timezone unrecognised Details: Sorry this is probably going to be a PITA issue.

Re: [BUGS] BUG #2062: Timezone unrecognised

2005-11-21 Thread Jim C. Nasby
On Mon, Nov 21, 2005 at 03:59:39PM +, David Begley wrote: The following bug has been logged online: Bug reference: 2062 Logged by: David Begley Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Windows Description:Timezone

Re: [BUGS] BUG #2048: initdb hang up

2005-11-21 Thread Qingqing Zhou
Acure [EMAIL PROTECTED] wrote As pgsql user i execute initdb : initdb -U pgsql -W -D datapl and it stop on : creating template1 database in tescik/base/1 ... Why you set datapl as the data directory but you get a tescik? Also, to see where it stops, you can add a -d flag to

Re: [BUGS] BUG #2060: Issue with Data base connection

2005-11-21 Thread Kris Jurka
On Mon, 21 Nov 2005, Manideep Kalisetty wrote: Bug reference: 2060 Email address: [EMAIL PROTECTED] PostgreSQL version: 7.2.2 Description:Issue with Data base connection Details: I am using postgresql-8.1dev-402.jdbc3.jar JDBC driver and websphere application server. Even

Re: [BUGS] BUG #2036: 8.1 JDBC busted date with INTERVAL update

2005-11-21 Thread Kris Jurka
On Fri, 11 Nov 2005, Reuben Pasquini wrote: Bug reference: 2036 Description:8.1 JDBC busted date with INTERVAL update Details: Something like this would work with the postgres-7.4 jdbc3.jar driver, but fails with the shown error with postgres-8.1 jdbc3.jar driver. Running with a