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 > >> 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 kill it

[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 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 ha

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 > > 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 kill it now. > > -- > Heikki Li

[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 should.

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

2010-01-21 Thread Wild Wezyr
2010/1/21 Heikki Linnakangas > The login screen says: > > Windows Server 2003 R2, Datacenter x64 Edition > > > What version of Postgres you have used? Is it 8.3.3 or 8.4.2 like mine? > > A fresh checkout from CVS HEAD. > > > What encoding/collation was your DB created with? Was it UTF8 / > > 'Pol

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 havin

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" 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 and/or Win64? 2

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' Rakowski wrote: > MD

Re: [BUGS] BUG #5292: Corrupted installer

2010-01-21 Thread Dave Page
On Thu, Jan 21, 2010 at 4:15 PM, Kevin Grittner wrote: > Adam 'foo-script' Rakowski wrote: >> MD5 of "One click installer" from >> http://www.enterprisedb.com/products/pgdownload.do , file >> "postgresql-8.4.2-1-windows.exe" is >> F59C645AC9CBFC5BBF1A52F734EAA550 MD5 of >> "postgresql-8.4.2-1-wind

[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" 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

[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 PRI

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

2010-01-21 Thread Tom Lane
Jaime Casanova 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); > NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index > "tcom_invitacion_pkey

[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 Tom Lane
"Allen Johnson" writes: > I did run into an issue where we are performing a group-by on about 10 > columns followed by an order-by of about 5 columns. This query was taking > twice as long as Oracle. When looking at the explain plan, Postgres seems to > be using all the columns in the group-by for

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 g

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_i

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 wrote: > Jaime Casanova 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); >> NOTICE:  ALTER TABLE / ADD PRI