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

2007-10-15 Thread Simon Riggs
On Mon, 2007-10-15 at 22:54 +0100, Dave Page wrote: > A change has been applied for GP compatibility. It will be in pgAdmin 1.8. Wow Dave, that was quick! It was the right place after all. :-) -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com ---(end of broadc

Re: [BUGS] Deferred FK / PK deletion problems

2007-10-15 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Tom Lane wrote: >> Came across an odd bug while dealing with deferred foreign keys. > I'm not convinced this is a bug. Can you elaborate on this? Am I doing something wrong in my app? Someone on irc pointed out that this affects more than def

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

2007-10-15 Thread Dave Page
> --- Original Message --- > From: Simon Riggs <[EMAIL PROTECTED]> > To: "Roberts, Jon" <[EMAIL PROTECTED]> > Sent: 15/10/07, 21:19:04 > Subject: Re: [BUGS] BUG #3667: Job scheduling with Greenplum fails > > On Thu, 2007-10-11 at 10:42 -0500, Roberts, Jon wrote: > > > Like I said in the

Re: [BUGS] BUG #3674: Unnecessary checkpoints by WAL Writer

2007-10-15 Thread Simon Riggs
On Fri, 2007-10-12 at 13:06 -0400, Tom Lane wrote: > "ITAGAKI Takahiro" <[EMAIL PROTECTED]> writes: > > WAL Writer requests unnecessary checkpoints with CHECKPOINT_CAUSE_XLOG. > > RedoRecPtr, declared in xlog.c, is initialized at StartupXLOG() but never > > updated in WAL Writer because it never ca

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

2007-10-15 Thread Simon Riggs
On Thu, 2007-10-11 at 10:42 -0500, Roberts, Jon wrote: > 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. You're missing

Re: [BUGS] IPv6 Support in 8.0.3

2007-10-15 Thread Stefan Kaltenbrunner
Kevin Kuhner wrote: > > Hello - > > Hope this is an appropriate mailing list for this question. Has anyone > gotten IPv6 support to work in version 8.0.3 for Windows? > > I've tried the 8.2.4 binaries and they do work, so I know that the > problem has been addressed somewhere along the line,

[BUGS] IPv6 Support in 8.0.3

2007-10-15 Thread Kevin Kuhner
Hello - Hope this is an appropriate mailing list for this question. Has anyone gotten IPv6 support to work in version 8.0.3 for Windows? I've tried the 8.2.4 binaries and they do work, so I know that the problem has been addressed somewhere along the line, but I'm not in a position to underg

[BUGS] BUG #3678: Folder Windows Don't Open Properly

2007-10-15 Thread Doug Bedell
The following bug has been logged online: Bug reference: 3678 Logged by: Doug Bedell Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: Mac OSX 10.4.10 Description:Folder Windows Don't Open Properly Details: Just downloaded 8.2.5. Attemptin

Re: [BUGS] BUG #3677: ceil/floor not working as expected

2007-10-15 Thread Heikki Linnakangas
Aleksander Machniak wrote: > ceil(0.4) != ceil(4/10) > > It's confusing. Ceil(4/10::numeric) is ok, but in mysql I don't need keep > casting in mind in this case. The underlying issue is that integer divided by an integer yields an integer, so 4/10 = 0. No, it's not going to be changed in Postgr

[BUGS] BUG #3677: ceil/floor not working as expected

2007-10-15 Thread Aleksander Machniak
The following bug has been logged online: Bug reference: 3677 Logged by: Aleksander Machniak Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: linux Description:ceil/floor not working as expected Details: ceil(0.4) != ceil(4/10) It's conf

Re: [BUGS] BUG #3676: README.TXT is duff gen

2007-10-15 Thread Dave Page
Rolf de By wrote: > The following bug has been logged online: > > Bug reference: 3676 > Logged by: Rolf de By > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.3 > Operating system: Windows > Description:README.TXT is duff gen > Details: > > I am nitpicking!

Re: [BUGS] pg_dump and password required

2007-10-15 Thread Devrim GÜNDÜZ
Hi, On Mon, 2007-10-15 at 01:05 +0400, Sergey Litvinenko wrote: > The problem is that I want to set up an automated backup with pg_dump, > but it asks for password interactively, rather then accept password > from either command-line option or from some config-file (e.g. > ~/.psqlrc) http://www.

[BUGS] pg_dump and password required

2007-10-15 Thread Sergey Litvinenko
Hello! I have Postgres configured so it requires password to access DB (in pg_hba.conf). The problem is that I want to set up an automated backup with pg_dump, but it asks for password interactively, rather then accept password from either command-line option or from some config-file (e.g. ~/.