Previous Topic Next Topic
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view


Lee Hyun soon
From: "Lee Hyun soon" <[hidden email]>
To: [hidden email]
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:      [hidden email]
PostgreSQL version: 8.0.2
Operating system:   Windows XP Professional SP1
Description:        pgsql odbc & ADO.NET

I'm a Corean Coder.

During C# Coding, I Found it.


Download #1 : (18.6 KB)
Download #2 : input_data.txt (3.2 KB) is Test Program(
input_data.txt is input Data

i use latest odbc provider, and it's database scheme is
 orgin_code char(17) NOT NULL DEFAULT to_char(now(),
 data text,
 datetime timestamp DEFAULT now(),
 bigo1 varchar(50),
 "year" char(4),
 data_gubun numeric DEFAULT 0
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.

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

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