Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] pgsql-bugs

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Lee Hyun soon <foolbabo(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [GENERAL] pgsql-bugs
Date: 2005-08-18 14:43:36
Message-ID: 1124376217.31094.137.camel@camel (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-generalpgsql-sql
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" <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/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


In response to

  • pgsql-bugs at 2005-08-17 05:29:45 from Lee Hyun soon

pgsql-sql by date

Next:From: Michael FuhrDate: 2005-08-18 15:05:46
Subject: Re: A Table's Primary Key Listing
Previous:From: Roger TannousDate: 2005-08-18 14:36:22
Subject: A Table's Primary Key Listing

pgsql-bugs by date

Next:From: Greg Sabino MullaneDate: 2005-08-18 14:52:02
Subject: Re: BUG #1831: plperl gives error after reconnect.
Previous:From: Bohdan LindaDate: 2005-08-18 12:47:56
Subject: BUG #1832: Can't create function in plpgsql which has more than 10 parameters

pgsql-general by date

Next:From: Oliver ElphickDate: 2005-08-18 14:47:43
Subject: Re: How to determine table schema in trigger function
Previous:From: Michael FuhrDate: 2005-08-18 14:43:06
Subject: Re: How to determine table schema in trigger function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group