[BUGS] expression_tree_walker() and primitive node types

2007-10-11 Thread Neil Conway
I wouldn't call this behavior buggy, but I found it somewhat surprising. expression_tree_walker() assumes that the walker has already been invoked on the current node (the node that a given recursive call of expression_tree_walker() has been invoked on). Therefore, calling expression_tree_walker()

Re: [BUGS] Deferred FK / PK deletion problems

2007-10-11 Thread Tom Lane
"Greg Sabino Mullane" <[EMAIL PROTECTED]> writes: > Came across an odd bug while dealing with deferred foreign keys. I'm not convinced this is a bug. regards, tom lane ---(end of broadcast)--- TIP 2: Don't 'kill -9' the pos

[BUGS] Deferred FK / PK deletion problems

2007-10-11 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Came across an odd bug while dealing with deferred foreign keys. Short story: messing around with the PK table screws up deferred constraints on the FK table. Here's a quick script to demonstrate. Confirmed as broken on today's cvs version, a

Re: [BUGS] BUG #3667: Job scheduling with Greenplum fails

2007-10-11 Thread Roberts, Jon
Like I said in the email, I think the best solution is to put the code in a function. However, after I inserted a total of 25 jobs, the difference is more noticeable and my sql is better in terms of cost and total time. vacuum analyze pgagent.pga_job; vacuum analyze pgagent.pga_jobclass; vacuum a

[BUGS] BUG #3671: if locale=french, service idles at 100% CPU

2007-10-11 Thread Nathanael TERRIEN
The following bug has been logged online: Bug reference: 3671 Logged by: Nathanael TERRIEN Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4+ Operating system: Windows XP SP2 Description:if locale=french, service idles at 100% CPU Details: Tested on 3 diff

Re: [BUGS] BUG #3667: Job scheduling with Greenplum fails

2007-10-11 Thread Andrew Sullivan
On Thu, Oct 11, 2007 at 07:31:44AM -0500, Roberts, Jon wrote: > The cost is significantly lower but the total runtime is higher. Um, so you want developers to change the thing so that it performs more slowly, but has a prettier estimate of how much work it's going to do? That seems like a poor

Re: [BUGS] BUG #3667: Job scheduling with Greenplum fails

2007-10-11 Thread Roberts, Jon
The original query: EXPLAIN ANALYZE SELECT *, (SELECT jlgstatus FROM pgagent.pga_joblog jl WHERE jl.jlgjobid = j.jobid ORDER BY jlgid DESC LIMIT 1) AS joblastresult FROM pgagent.pga_job j JOIN pgagent.pga_jobclass cl ON cl.jclid=jobjclid LEFT OUTER JOIN p

[BUGS] BUG #3670: Exception thrown when attempting to debug

2007-10-11 Thread Ognjen Babic
The following bug has been logged online: Bug reference: 3670 Logged by: Ognjen Babic Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3beta-1 Operating system: Windows 2003 Server Description:Exception thrown when attempting to debug Details: Exception is thr

Re: [BUGS] BUG #3669: cann't use UTF8 as server side encoding

2007-10-11 Thread Hiroshi Saito
Hi. Yes, you look at the same thing as this. http://winpg.jp/~saito/pginstaller/pginstaller_8.3.beta1-error1.png We will correct it after discussion. Please expect the following version. Thanks! Regrad, Hiroshi Saito - Original Message - From: "huanghongdong" <[EMAIL PROTECTED]> To

[BUGS] BUG #3669: cann't use UTF8 as server side encoding

2007-10-11 Thread huanghongdong
The following bug has been logged online: Bug reference: 3669 Logged by: huanghongdong Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3b1 Operating system: windowsXP Description:cann't use UTF8 as server side encoding Details: use the installer to install 8.