Re: [BUGS] BUG #5290: Simple loop with insert into and check to avoid duplicate values fails

2010-01-21 Thread Heikki Linnakangas
Wild Wezyr wrote: 2010/1/20 Heikki Linnakangas heikki.linnakan...@enterprisedb.com I happen to have access to a Win32 virtual machine just now. CVS HEAD, built from sources on the VM. Seems to work fine. The test case runs for ages, I'm at about 1/3 through it, and no errors this far. I'm

[BUGS] Re: BUG #5290: Simple loop with insert into and check to avoid duplicate values fails

2010-01-21 Thread Milen A. Radev
Heikki Linnakangas написа: Wild Wezyr wrote: 2010/1/20 Heikki Linnakangas heikki.linnakan...@enterprisedb.com I happen to have access to a Win32 virtual machine just now. CVS HEAD, built from sources on the VM. Seems to work fine. The test case runs for ages, I'm at about 1/3 through it, and

Re: [BUGS] BUG #5290: Simple loop with insert into and check to avoid duplicate values fails

2010-01-21 Thread Wild Wezyr
2010/1/20 Heikki Linnakangas heikki.linnakan...@enterprisedb.com I happen to have access to a Win32 virtual machine just now. CVS HEAD, built from sources on the VM. Seems to work fine. The test case runs for ages, I'm at about 1/3 through it, and no errors this far. I'm going to have to

[BUGS] PHP .zip File

2010-01-21 Thread Antoine Banks
Hi.Do you have a downloadable .zip file that I can download with individual php files of the windows version of PostgreSQL and move the php files into a folder inside my cpanel instead of having to install PostgreSQL directly onto my computer? If not, will you PLEASE create one; I think you

Re: [BUGS] PHP .zip File

2010-01-21 Thread Scott Mead
On Thu, Jan 21, 2010 at 3:53 AM, Antoine Banks antoinelba...@assistantdirectors.com wrote: Hi. Do you have a downloadable .zip file that I can download with individual php files of the windows version of PostgreSQL and move the php files into a folder inside my cpanel instead of having to

Re: [BUGS] Re: BUG #5290: Simple loop with insert into and check to avoid duplicate values fails

2010-01-21 Thread Tom Lane
Milen A. Radev mi...@radev.net writes: I reproduced it on Windows Vista 64-bit SP2 with version 8.4.2 (installed by using the One-click installer from EnterpriseDB): OK, so that means WildWezyr isn't just seeing things. Possibilities that occur to me now: 1. Maybe it's specific to Vista

Re: [BUGS] BUG #5292: Corrupted installer

2010-01-21 Thread Kevin Grittner
Adam, please keep the discussion on-list. For one thing, I don't have any Windows machines to test this on; I was just trying to elicit enough information that when someone who did looked at the thread, they'd have enough information to try to replicate it. Adam 'foo-script'

[BUGS] Re: BUG #5290: Simple loop with insert into and check to avoid duplicate values fails

2010-01-21 Thread Milen A. Radev
Tom Lane написа: Milen A. Radev mi...@radev.net writes: I reproduced it on Windows Vista 64-bit SP2 with version 8.4.2 (installed by using the One-click installer from EnterpriseDB): OK, so that means WildWezyr isn't just seeing things. Possibilities that occur to me now: 1. Maybe it's

[BUGS] add primary key doesn't block?

2010-01-21 Thread Jaime Casanova
Hi, I'm testing the migration procedure for a client, we want to migrate from 8.3.6 to 8.4 When we perform a test migration of the data we found some errors on the logs, one of them is this one: mic=# ALTER TABLE tcom_invitacion ADD primary key (id_invitacion); NOTICE: ALTER TABLE / ADD

[BUGS] BUG #5294: Sorts on more than just the order-by clause

2010-01-21 Thread Allen Johnson
The following bug has been logged online: Bug reference: 5294 Logged by: Allen Johnson Email address: akjohnso...@gmail.com PostgreSQL version: 8.4.2 Operating system: Red Hat ES 5.4 Description:Sorts on more than just the order-by clause Details: I've been porting

Re: [BUGS] BUG #5294: Sorts on more than just the order-by clause

2010-01-21 Thread Allen Johnson
In practice, I really doubt this would make a measurable performance difference, since most row comparisons would arrive at a result before they got to the lowest-order columns. I think your gripe may actually have to do with a misestimate of the relative costs of hash- and sort-based

Re: [BUGS] add primary key doesn't block?

2010-01-21 Thread Craig Ringer
Jaime Casanova wrote: Hi, I'm testing the migration procedure for a client, we want to migrate from 8.3.6 to 8.4 When we perform a test migration of the data we found some errors on the logs, one of them is this one: mic=# ALTER TABLE tcom_invitacion ADD primary key (id_invitacion);

Re: [BUGS] add primary key doesn't block?

2010-01-21 Thread Jaime Casanova
On Thu, Jan 21, 2010 at 12:45 PM, Tom Lane t...@sss.pgh.pa.us wrote: Jaime Casanova jcasa...@systemguards.com.ec writes: When we perform a test migration of the data we found some errors on the logs, one of them is this one: mic=# ALTER TABLE tcom_invitacion ADD primary key (id_invitacion);