From: Lee Hyun soon <foolbabo@gmail.com>
To: pgsql-sql@postgresql.org
To: pgsql-general@postgresql.org
To: pgsql-bugs-owner@postgresql.org
Subject: pgsql-bugs
Date: Wed, 17 Aug 2005 14:29:45 +0900
Message-ID: <138585a3050816222916cde44f@mail.gmail.com> (raw)
In-Reply-To: <518f5bd0c081628fd439aadbbcc5eb374cd1925a@postgresql.org>
References: <518f5bd0c081628fd439aadbbcc5eb374cd1925a@postgresql.org>
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=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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: foolbabo@gmail.com, pgsql-general@postgresql.org, pgsql-bugs-owner@postgresql.org
Subject: Re: pgsql-bugs
In-Reply-To: <138585a3050816222916cde44f@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox