[BUGS] When dealing with 'bigint'or 'int8', the command 'copy'doesn't work

2001-08-01 Thread Dong, Meng
line 1, Bad int8 external representation "'123'"   (My PostgreSQL is v7.1) I would appreciate any help or advice.       thanks in advance,       Dong, Meng[EMAIL PROTECTED]

RE: [BUGS] 'order by' and 'desc' not working in subquery using 'not in'

2001-07-31 Thread Dong, Meng
Title: Hi Rahul,Have you tried to quote each table name and column name by  " , and constant by ' ? In your case, try delete from "reporttable" where ( "srvServerid" = 'serverid') and( "rptreportid" not in(select "rptreportid" from "reporttable"where ( "srvserverid" = 'serverid' order

[BUGS] 'int8' is not always OK, 'bigint' seems to be more reliable instead.

2001-07-26 Thread Dong, Meng
Title: Dear Bug Killer,I have a bug to report.As we know, for PostgreSQL, the data type 'bigint' can also be called 'int8'. Ideally, they should be identical.But, when I create a table called XXX, if I define a column's type as 'bigint', it's Okay. Otherwise, if I choose 'int8' instead