BUG #1829: pgsql odbc & ADO.NET(modify)

From: "Lee Hyun soon" <foolbabo(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1829: pgsql odbc & ADO.NET(modify)
Date: 2005-08-17 08:13:28
Message-ID: 20050817081328.DB7F4F0C12@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1829
Logged by: Lee Hyun soon
Email address: foolbabo(at)gmail(dot)com
PostgreSQL version: 8.0.2
Operating system: Windows XP Professional SP1
Description: pgsql odbc & ADO.NET(modify)
Details:

[sorry miss type long,,,sort;;;
modify long..
long is correct..]

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 long string in "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.

Browse pgsql-bugs by date

  From Date Subject
Next Message Bernard 2005-08-17 08:22:16 BUG #1830: Non-super-user must be able to copy from a file
Previous Message Lee Hyun soon 2005-08-17 05:47:54 BUG #1828: pgsql odbc & ADO.NET