Re: [BUGS] BUG #4925: "select ... for update" doesn't affect rows from sub-query

2009-07-29 Thread Robert Haas
On Thu, Jul 16, 2009 at 12:34 PM, Steve Caligo wrote: > > The following bug has been logged online: > > Bug reference:      4925 > Logged by:          Steve Caligo > Email address:      steve.cal...@ctie.etat.lu > PostgreSQL version: 8.3.7 and 8.4.0 > Operating system:   Archlinux and Gentoo 8.3.7,

Re: [BUGS] BUG #4950: Problem in Job scheduling in Advanced postgre sql

2009-07-29 Thread Scott Mead
If you're using Postgres Plus Advanced Server, that is a commercial product released by EnterpriseDB. It is not supported here. Please use ' supp...@enterprisedb.com' --Scott

Re: [BUGS] BUG #4954: very slow query with 2 statements

2009-07-29 Thread Mikael Krantz
This is not a bug. Each query requires a round-trip to the server so it is natural that a lot of queries take additional time. /M On Wed, Jul 29, 2009 at 1:01 PM, Axel Fix wrote: > > The following bug has been logged online: > > Bug reference:      4954 > Logged by:          Axel Fix > Email addr

Re: [BUGS] BUG #4952: commit_delay ignored because CountActiveBackends always returns zero

2009-07-29 Thread Tom Lane
"Jeff Janes" writes: > This seems to be a bug introduced by: > http://archives.postgresql.org/pgsql-committers/2009-03/msg00259.php > I believe the source of the bug is the addition to that file of > + if (proc != NULL) > + continue; > The sense of this test sho

[BUGS] BUG #4954: very slow query with 2 statements

2009-07-29 Thread Axel Fix
The following bug has been logged online: Bug reference: 4954 Logged by: Axel Fix Email address: axel@sitqsystems.com PostgreSQL version: 8.3 and 8.4 Operating system: Windows XP Description:very slow query with 2 statements Details: Hello, I have a simple er-m

Re: [BUGS] BUG #4945: Parallel update(s) gone wild

2009-07-29 Thread Dan Boeriu
Attached is the reproducible test case - I was able to reproduce the problem on 32 and 64 bit 8.3.6 and 8.4.0 RedHat 5.3 kernel 2.6.18-128.1.16.el5 #1 SMP JUST IN CASE - if the second update ever finishes just do a couple of times: INSERT INTO xxx SELECT * FROM xxx; That should do it. Please

[BUGS] BUG #4952: commit_delay ignored because CountActiveBackends always returns zero

2009-07-29 Thread Jeff Janes
The following bug has been logged online: Bug reference: 4952 Logged by: Jeff Janes Email address: jeff.ja...@gmail.com PostgreSQL version: 8.4.0 Operating system: Linux 2.4.21-15.0.3.ELsmp Description:commit_delay ignored because CountActiveBackends always returns ze

[BUGS] Re: BUG #4949: NOT IN is prohibitive slower than the rewrite for medium to large sets

2009-07-29 Thread Greg Stark
On Wed, Jul 29, 2009 at 11:34 AM, Ole Tange wrote: > EXPLAIN tells me the LEFT JOIN does table scan as well. It seems the > primary reason why your LEFT JOIN is faster than my 3 line alternative > is because I do DELETEs, which is slow. So thank you for the LEFT JOIN > idea. If you don't want the

Re: [BUGS] BUG #4949: NOT IN is prohibitive slower than the rewrite for medium to large sets

2009-07-29 Thread Ole Tange
On Wed, Jul 29, 2009 at 12:16 AM, Tom Molesworth wrote: > Ole Tange wrote: >> On Tue, Jul 28, 2009 at 3:47 PM, Tom Lane wrote: >>> "Ole Tange" writes: >>> (modulo NULLs which seem to always cause problems in NOT INs). >>> >>> Let's see, you understand that the rewrite violates the SQL standar

Re: [BUGS] BUG #4950: Problem in Job scheduling in Advanced postgre sql

2009-07-29 Thread Robert Haas
On Tue, Jul 28, 2009 at 9:26 AM, Ramakanth wrote: > > The following bug has been logged online: > > Bug reference:      4950 > Logged by:          Ramakanth > Email address:      ramaka...@iblesoft.com > PostgreSQL version: Advanced 8.3 R2 > Operating system:   Windows xp > Description:        Prob

Re: [BUGS] BUG #4953: Crash with xml functions

2009-07-29 Thread Peter Eisentraut
On Wednesday 29 July 2009 11:39:03 Giorgio Valoti wrote: > I get a crash when I invoke xml function like xml_is_well_formed. > > It works with static xml but not if it’s dynamically generated. > > It crashes even if I first create the xml dynamically and then invoke the > function with static text.

Re: [BUGS] BUG #4951: installation dir wrong for libpq compilation

2009-07-29 Thread Dave Page
On Tue, Jul 28, 2009 at 11:57 PM, Jim Michaels wrote: > > The following bug has been logged online: > > Bug reference:      4951 > Logged by:          Jim Michaels > Email address:      jmich...@yahoo.com > PostgreSQL version: 8.4.0 > Operating system:   Win XP Pro Sp3 > Description:        install

[BUGS] BUG #4953: Crash with xml functions

2009-07-29 Thread Giorgio Valoti
The following bug has been logged online: Bug reference: 4953 Logged by: Giorgio Valoti Email address: giorgi...@me.com PostgreSQL version: 8.4.0 Operating system: Mac OS X 10.5.8 Description:Crash with xml functions Details: I get a crash when I invoke xml function

Re: [BUGS] BUG #4951: installation dir wrong for libpq compilation

2009-07-29 Thread Peter Eisentraut
On Wednesday 29 July 2009 01:57:50 Jim Michaels wrote: > it is impossible to compile in libpq headers unless the installation > directory for postgres has no spaces. compilers such as gcc/mingw don't > like that. Proof please? -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To m

Re: [BUGS] BUG #4951: installation dir wrong for libpq compilation

2009-07-29 Thread Craig Ringer
On Tue, 2009-07-28 at 22:57 +, Jim Michaels wrote: > The following bug has been logged online: > > Bug reference: 4951 > Logged by: Jim Michaels > Email address: jmich...@yahoo.com > PostgreSQL version: 8.4.0 > Operating system: Win XP Pro Sp3 > Description:install