Re: [BUGS] [GENERAL] pgsql-bugs

#1

Redirecting this to pgsql-bugs where it belongs.

Robert Treat

On Wed, 2005-08-17 at 01:29, Lee Hyun soon wrote:

Quote:

From: "Lee Hyun soon" <foolbabo (AT) gmail (DOT) com
To: pgsql-bugs (AT) postgresql (DOT) 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 (AT) gmail (DOT) 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/...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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] [GENERAL] pgsql-bugs

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] [GENERAL] pgsql-bugs - 08-18-2005 , 09:51 AM