Redirecting this to pgsql-bugs where it belongs. Robert Treat
On Wed, 2005-08-17 at 01:29, Lee Hyun soon wrote: > From: "Lee Hyun soon" <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] > 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. > > ---------------------------(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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
