From: "Lee Hyun soon" <foolbabo@xxxxxxxxx> To: pgsql-bugs@xxxxxxxxxxxxxx Date: Wed, 17 Aug 2005 05:36:23 +0100 (BST) Subject: BUG #1826: pgsql odbc & ADO.NET The following bug has been logged online: Bug reference: 1826 Logged by: Lee Hyun soon Email address: foolbabo@xxxxxxxxx PostgreSQL version: 8.0.2 Operating system: Windows XP Professional SP1 Description: pgsql odbc & ADO.NET Details: I'm a Corean Coder. During C# Coding, I Found it. ----------------- http://www.windows.or.kr/zboard/bbs/view.php?id=app1data&page=1&sn1=&divpage =1&sn=off&ss=on&sc=on&select_arrange=headnum&desc=asc&no=6 ------------------- Download #1 : RichEditBoxTest.zip (18.6 KB) Download #2 : input_data.txt (3.2 KB) RichEditBoxTest.zip is Test Program(C#.net) input_data.txt is input Data i use latest odbc provider, and it's database scheme is ====================== CREATE TABLE nmsdata ( orgin_code char(17) NOT NULL DEFAULT to_char(now(), 'yyyymmddHH24MISSMS'::text), data text, datetime timestamp DEFAULT now(), bigo1 varchar(50), "year" char(4), data_gubun numeric DEFAULT 0 ) WITHOUT OIDS; ALTER TABLE nmsdata OWNER TO postgres; GRANT ALL ON TABLE nmsdata TO postgres; GRANT ALL ON TABLE nmsdata TO public; ============== and, odbc dsn is "remote" the problem is short string is "insert" DML processing completely. and long string is also. but, after shot string "select" DML, data's tail is broken. u see my source(if u know C# Language and have .Net Comfiler), u catch this problem. ----------------------------- i cannot use english T^T well. i hope that u catch my problem. and this problem will be solved. - Corean(Korean) Lee. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
