[BUGS] Windows 8.0 beta on Server 2003 Installer problem

2004-09-15 Thread Bender, Cheryl
Title: Windows 8.0 beta on Server 2003 Installer problem This may not be a bug but I only have one Windows 2003 Server to try it on.  The package installed fine on Windows XP Professional and Windows 2000 professional. Launching the installer it looks fine until it gets to the screen where y

Re: [BUGS] Windows 8.0 beta on Server 2003 Installer problem

2004-09-15 Thread Harald Armin Massa
Cheryl, you can learn more about the problem by doing some logging... msiexec /Lv c:\\temp\\nase2.txt /i postgresql-8.0-beta2-dev3.msi "c:\\temp\\nase2.txt" is the file wereto the logging is done. You can read there more about the exact error ... what was done last. Best go from the end, where

Re: [BUGS] Windows 8.0 beta on Server 2003 Installer problem

2004-09-15 Thread Harald Armin Massa
Cheryl, I digged through you log, and stumbled: ### MSI (c) (B0:94): Product: PostgreSQL 8.0-beta2-dev3 -- The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code

Re: [BUGS] Windows 8.0 beta on Server 2003 Installer problem

2004-09-15 Thread Bender, Cheryl
I wondered about the corrupt installer problem (since I cannot download files here I downloaded it at home and put on CD), but it installed fine on Windows XP Professional. Perhaps this is a corruption that XP forgives but 2003 does not. I've had some problems with 2003 on this box (Dell GX2

Re: [BUGS] Windows 8.0 beta on Server 2003 Installer problem

2004-09-15 Thread Magnus Hagander
> I digged through you log, and stumbled: > > ### > MSI (c) (B0:94): Product: PostgreSQL 8.0-beta2-dev3 -- The > installer has encountered an unexpected error installing this > package. This may indicate a problem with this package. The > erro

[BUGS] character and text comparison

2004-09-15 Thread Jacek Rembisz
Hello, When I run SELECT ' '::character = ' '::text; on PostgreSQL 7.4 the result is `false' while on 7.3 and 7.2 instalations result is `true' Is this an intentional change? regards, Jacek Rembisz ---(end of broadcast)--- TIP 7: don't forge

Re: [BUGS] Windows 8.0 beta on Server 2003 Installer problem

2004-09-15 Thread Bender, Cheryl
<> Yes--just to make sure I installed another MSI-based package and it worked fine. Cheryl Bender -Original Message- From: Magnus Hagander [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 15, 2004 11:14 AM To: Harald Armin Massa; Bender, Cheryl; [EMAIL PROTECTED] Subject: RE: [BUGS]

Re: [BUGS] character and text comparison

2004-09-15 Thread Tom Lane
Jacek Rembisz <[EMAIL PROTECTED]> writes: > When I run SELECT ' '::character = ' '::text; > on PostgreSQL 7.4 the result is `false' > while on 7.3 and 7.2 instalations result is `true' > Is this an intentional change? Yes. We now strip trailing blanks when converting a char(n) value to text.

Re: [BUGS] BUG #1252: Optimization of SELECT for NOT NULL case

2004-09-15 Thread Bruno Wolff III
On Tue, Sep 14, 2004 at 00:57:07 +0100, PostgreSQL Bugs List <[EMAIL PROTECTED]> wrote: > > Description:Optimization of SELECT for NOT NULL case > > Details: > > CREATE TABLE x (id int4 NOT NULL); > Populate table, for instance, 10M rows; > SELECT count(*) from x WHERE x IS NULL; > Op

Re: [BUGS] character and text comparison

2004-09-15 Thread Jacek Rembisz
On Wed, Sep 15, 2004 at 12:43:11PM -0400, Tom Lane wrote: > Jacek Rembisz <[EMAIL PROTECTED]> writes: > > When I run SELECT ' '::character = ' '::text; > > on PostgreSQL 7.4 the result is `false' > > while on 7.3 and 7.2 instalations result is `true' > > > Is this an intentional change? > > Yes

Re: [BUGS] BUG #1252: Optimization of SELECT for NOT NULL case

2004-09-15 Thread Tom Lane
Bruno Wolff III <[EMAIL PROTECTED]> writes: > On Tue, Sep 14, 2004 at 00:57:07 +0100, >> CREATE TABLE x (id int4 NOT NULL); >> SELECT count(*) from x WHERE x IS NULL; >> Optimizator should rewrite "x IS NULL" to simple "false" > Based on responses to other optimization requests I have seen, I thin

Re: [BUGS] Windows 8.0 beta on Server 2003 Installer problem

2004-09-15 Thread Bender, Cheryl
I was able to install on a another 2003 server, so it must be a problem with my machine. Although I sure wish I knew what the problem is, since the other server is almost identical. It's a good thing in the end though because that server is a much better test platform. Thanks all for your sugges

Re: [BUGS] BUG #1252: Optimization of SELECT for NOT NULL case

2004-09-15 Thread Alexander Kirpa
On 15 Sep 2004, at 12:21, Bruno Wolff III wrote: > On Tue, Sep 14, 2004 at 00:57:07 +0100, > PostgreSQL Bugs List <[EMAIL PROTECTED]> wrote: > > > > Description:Optimization of SELECT for NOT NULL case > > > > Details: > > > > CREATE TABLE x (id int4 NOT NULL); > > Populate table, fo

Re: [BUGS] Pb with ecpg and include file on PG 8.0.0

2004-09-15 Thread Valerie Schneider DSI/DEV
>Date: Tue, 14 Sep 2004 09:27:41 +0200 >From: Michael Meskes <[EMAIL PROTECTED]> >To: Valerie Schneider DSI/DEV <[EMAIL PROTECTED]> >Cc: [EMAIL PROTECTED] >Subject: Re: [BUGS] Pb with ecpg and include file on PG 8.0.0 >Mime-Version: 1.0 >Content-Disposition: inline >User-Agent: Mutt/1.5.6+20040722

[BUGS] Cannot install properly on WinXP...

2004-09-15 Thread Luis Antonio Tama Wong
Hello! I have some problems when installing postgresql-8.0-beta2-dev3 on my WinXP system. During the installation process, after the DOS batch process, I get the following error messages: "Failed to connect to database. Procedural languages files are installed, but are not activated in any databas

[BUGS] Bug in boolean columns on win2k

2004-09-15 Thread Mads Peter Henderson
RE-POST: This is a repost. Our mailserver was out of order when sending this report yesterday, and I can't find the post on the buglist yet. Sorry for any inconvenience. BUG: I have a table with the following column, from "psql \d": showemail| boolean | When I try to inse

[BUGS] Bug in boolean columns on win2k

2004-09-15 Thread Mads Peter Henderson
I have a table with the following column, from psql \d: showemail| boolean | When I try to insert data data into this through jdbc, I get the following error: java.sql.SQLException: ERROR: column "showemail" is of type boolean but expression is of type text at org

Re: [BUGS] Bug in boolean columns on win2k

2004-09-15 Thread Kris Jurka
On Wed, 15 Sep 2004, Mads Peter Henderson wrote: > I have a table with the following column, from "psql \d": > showemail| boolean | > > When I try to insert data data into this through jdbc, I get the > following error: > java.sql.SQLException: ERROR: column "showemail"

Re: [BUGS] Cannot install properly on WinXP...

2004-09-15 Thread Harald Armin Massa
Luis, sad sad story. PostgreSQL on Windows is very challenged by LSP-Applications running on the same machine. LSP = Layered Service Provider That my be Antivir Software, or on my machine it was "CoolSpot personal ID", an age verification system to see adult content. Please check the extensive