Re: [BUGS] Integer/BigInt Implicit Typing Bug

2004-02-12 Thread Tom Lane
[EMAIL PROTECTED] writes: > In the 7.4.1 release, I've found that it implicitly types INT_MIN, > -2147483648, as a 64-bit integer instead of a 32-bit integer. This is not a bug, and the reason is that "-" is a separate operator. "2147483648" is an int8 constant. regards, t

[BUGS] Integer/BigInt Implicit Typing Bug

2004-02-12 Thread pmcneill
In the 7.4.1 release, I've found that it implicitly types INT_MIN, -2147483648, as a 64-bit integer instead of a 32-bit integer. Here's a test case: select "bit"(-2147483647); bit -- 1001 select "bit"(-2

[BUGS] socket error while creating database in windows98

2004-02-12 Thread Sh A Guru Prasad
We have installed beta version of postgres 7.2.1 on windows98. Initdb went through. while createing c:\>pgsql>creatdb sample following error message is being displayed psql.exe: cound not connect to server: socket error, No decription available (0X274D) is the server running on host lo