[BUGS] Bug #642: Need "Alter table drop column"

2002-04-22 Thread pgsql-bugs
Richard Neill ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Need "Alter table drop column" Long Description Please can we have the option of "Alter table drop column "? Otherwise, correcting a simple mistake of setting up a

[BUGS] Bug #641: LIBPQ Linking with the static library on the WIN32 platform fails connections with "unknown host name".

2002-04-22 Thread pgsql-bugs
Jason Erickson ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description LIBPQ Linking with the static library on the WIN32 platform fails connections with "unknown host name". Long Description I was having problems connecting up to a r

Re: [BUGS] Bug #638: Buggy select statment with numeric

2002-04-22 Thread Thomas Lockhart
> A select statement with a where clause on a numeric column tested > for equality against null always return empty result. This is correct behavior per SQL9x standards. NULL is *not* a value, but represents the absense of information so tests FALSE in comparisons of any kind. hth

[BUGS] Bug #640: ECPG: inserting float numbers

2002-04-22 Thread pgsql-bugs
Edward ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description ECPG: inserting float numbers Long Description Inserting records with single precision real variables having small value (range 1.0e-6 or less) frequently results in error

Re: [BUGS] 7.2.1: pg_dump of UNIONed VIEWs broken

2002-04-22 Thread Tom Lane
Ian Morgan <[EMAIL PROTECTED]> writes: > Even if adding ORDER BY to a UNION is really sub-optimal SQL, shouldn't > pg_dump (and even psql's \d ) produce SQL that actually > works I didn't say it wasn't a bug ;-) ... just pointing out that fixing it doesn't seem very high priority. I'll do someth

Re: [BUGS] Bug #638: Buggy select statment with numeric

2002-04-22 Thread Tom Lane
[EMAIL PROTECTED] writes: >> select * from t where n ISNULL; > n | s > ---+-- >| asdasdasd >| > (2 rows) >> select * from t where n=NULL; > n | s > ---+--- > (0 rows) This is not a bug. However, you can make 7.2 work in that braindead Microsoft-compatible

Re: [BUGS] 7.2.1: pg_dump of UNIONed VIEWs broken

2002-04-22 Thread Tom Lane
Ian Morgan <[EMAIL PROTECTED]> writes: > The SQL for CREATE VIEW as output by pg_dump generates an error, because the > appropriate nesting of SELECTs with parentheses is missing: Hmm. You shouldn't *need* parentheses in most cases ... > CREATE VIEW "agents" as ( > ( > SELECT DI

Re: [BUGS] Bug #638: Buggy select statment with numeric

2002-04-22 Thread Stephan Szabo
On Mon, 22 Apr 2002 [EMAIL PROTECTED] wrote: > Florian Steffen ([EMAIL PROTECTED]) reports a bug with a severity of 3 > The lower the number the more severe it is. > > Short Description > Buggy select statment with numeric > > Long Description > A select statement with a where clause on a numeri

[BUGS] Escaping of special characters in ARRAYs is broken

2002-04-22 Thread Gerhard Häring
POSTGRESQL BUG REPORT TEMPLATE Your name : Gerhard Häring Your email address : [EMAIL P

[BUGS] Bug #639: JDBC interface, ResultSet.getObject on with an array of char is crashing.

2002-04-22 Thread pgsql-bugs
Florian Steffen ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description JDBC interface, ResultSet.getObject on with an array of char is crashing. Long Description Using the JDBC interface version 7.2, when calling ResultSet.getObject

[BUGS] Bug #638: Buggy select statment with numeric

2002-04-22 Thread pgsql-bugs
Florian Steffen ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description Buggy select statment with numeric Long Description A select statement with a where clause on a numeric column tested for equality against null always return empt

Re: [BUGS] Escaping of special characters in ARRAYs is broken

2002-04-22 Thread Gerhard Häring
* Tom Lane <[EMAIL PROTECTED]> [2002-04-21 11:12 -0400]: > Gerhard =?iso-8859-15?Q?H=E4ring?= <[EMAIL PROTECTED]> writes: > > You can see the inconsistency yourself when you try to insert a special > > character like \005 into a varchar array. IMO This should work with inserting > > '{"\\005"}', b