X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id E6A10529C6
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Wed, 17 Aug 2005 02:29:47 -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 37443-09
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Wed, 17 Aug 2005 05:29:45 +0000 (GMT)
Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.195])
	by svr1.postgresql.org (Postfix) with ESMTP id 66912528CD
	for <pgsql-general@postgresql.org>;
	Wed, 17 Aug 2005 02:29:44 -0300 (ADT)
Received: by rproxy.gmail.com with SMTP id r35so87677rna
	for <pgsql-general@postgresql.org>;
	Tue, 16 Aug 2005 22:29:45 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=pYFWv6KuzCFBYoSOxPr7cccAlstueM4wLMLldfzR/2Ib/MhvYCHnie4QDJB/qjsSN3CoSy4zXoYpQP81l9MhRqps29ilwYRvFmkFS5cpKS2LXDP1bHJm9fOH1P33/jbGD3e2QH63FZGWPac73eZHA2mS7QxNzC79WS6y/Lji0BA=
Received: by 10.38.59.29 with SMTP id h29mr10767rna;
	Tue, 16 Aug 2005 22:29:45 -0700 (PDT)
Received: by 10.38.151.34 with HTTP; Tue, 16 Aug 2005 22:29:45 -0700 (PDT)
Message-ID: <138585a3050816222916cde44f@mail.gmail.com>
Date: Wed, 17 Aug 2005 14:29:45 +0900
From: Lee Hyun soon <foolbabo@gmail.com>
To: pgsql-sql@postgresql.org, pgsql-general@postgresql.org,
	pgsql-bugs-owner@postgresql.org
Subject: pgsql-bugs
In-Reply-To: <518f5bd0c081628fd439aadbbcc5eb374cd1925a@postgresql.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <518f5bd0c081628fd439aadbbcc5eb374cd1925a@postgresql.org>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.024 required=5 tests=[RCVD_BY_IP=0.024]
X-Spam-Level: 
X-Archive-Number: 200508/833
X-Sequence-Number: 82241

From: "Lee Hyun soon" <foolbabo@gmail.com>
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=3Dapp1data&page=3D1&sn1=3D&=
divpage
=3D1&sn=3Doff&ss=3Don&sc=3Don&select_arrange=3Dheadnum&desc=3Dasc&no=3D6
-------------------

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
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
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;
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
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.