X-Original-To: pgsql-bugs-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DD326529E7 for ; Thu, 18 Aug 2005 11:43:43 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 34067-03 for ; Thu, 18 Aug 2005 14:43:38 +0000 (GMT) Received: from bramble.mmrd.com (bramble.mmrd.com [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id 133BD529FC for ; Thu, 18 Aug 2005 11:43:36 -0300 (ADT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by bramble.mmrd.com (8.12.8/8.12.8) with ESMTP id j7IEsZoJ026442; Thu, 18 Aug 2005 10:54:35 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [10.225.10.110]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id j7IEhbd32613; Thu, 18 Aug 2005 10:43:38 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id 2LM0J1F3; Thu, 18 Aug 2005 10:43:36 -0400 Subject: Re: [GENERAL] pgsql-bugs From: Robert Treat To: Lee Hyun soon Cc: pgsql-bugs@postgresql.org In-Reply-To: <138585a3050816222916cde44f@mail.gmail.com> References: <518f5bd0c081628fd439aadbbcc5eb374cd1925a@postgresql.org> <138585a3050816222916cde44f@mail.gmail.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 18 Aug 2005 10:43:36 -0400 Message-Id: <1124376217.31094.137.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.03 required=5 tests=[AWL=0.030] X-Spam-Level: X-Archive-Number: 200508/141 X-Sequence-Number: 12565 Redirecting this to pgsql-bugs where it belongs. Robert Treat On Wed, 2005-08-17 at 01:29, Lee Hyun soon wrote: > From: "Lee Hyun soon" > To: pgsql-bugs@postgresql.org > 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@gmail.com > 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 -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL