Hi, I've created a new bug category: "database specific"
The bellow issue was re-seted to that from "server specific" and turned "High". Thanks for using Bugsie to post your bugs. Best regards, Lopo ---------- Mensagem Reencaminhada ---------- Subject: [CARE2X - HIS 0000054]: problem with columns of int2 datatype on a PostgreSQL 8.0 database Date: Quarta, 16 de Fevereiro de 2005 20:57 From: [EMAIL PROTECTED] To: [email protected] The following NEW bug has been ADDED. ======================================================================= http://www.care2x.org/bugsie/view_bug_page.php?f_id=54 ======================================================================= Reporter: Anonymous Handler: ======================================================================= Project: CARE2X - HIS Bug ID: 0000054 Category: server specific Reproducibility: always Severity: block Priority: normal Status: new ======================================================================= Date Submitted: 02-16-05 21:57 CET Last Modified: 02-16-05 21:57 CET ======================================================================= Summary: problem with columns of int2 datatype on a PostgreSQL 8.0 database Description: basicly all queries on int2 datatypes fail because of a conversion of text to int which is defined as explicit in PostgreSQL 8.0 example columns : care_department.is_inactive, care_encounter.is_discharged sample query: SELECT *, LD_var AS "LD_var" FROM care_department WHERE (is_inactive='' OR is_inactive='0') AND status NOT IN ('deleted','hidden','inactive','void') ORDER BY name_formal ======================================================================= ------------------------------------------------------- -- Care2x - Integrated Healthcare Environment http://www.care2x.org mailto:[EMAIL PROTECTED] Project Team Member Humaneasy Consulting Rua Jo�o Domingos Bomtempo, 17 Bloco 3, Edif�cio 2 - 3 D Qta Fonte da Prata (Norte) 2680-128 ALHOS VEDROS Portugal - EU M. (+351) 933 177 386 T. (+351) 212 801 250 http://www.humaneasy.com mailto:[EMAIL PROTECTED] ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_ide95&alloc_id396&op=click _______________________________________________ Care2002-developers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/care2002-developers
