pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedpgsql-bugs
2+ messages / 2 participants
[nested] [flat]
* pgsql-bugs
@ 2005-08-17 05:29 Lee Hyun soon <foolbabo@gmail.com>
2005-08-18 14:43 ` Re: [GENERAL] pgsql-bugs Robert Treat <xzilla@users.sourceforge.net>
0 siblings, 1 reply; 2+ messages in thread
From: Lee Hyun soon @ 2005-08-17 05:29 UTC (permalink / raw)
To: pgsql-sql; pgsql-general@postgresql.org; pgsql-bugs-owner@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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [GENERAL] pgsql-bugs
2005-08-17 05:29 pgsql-bugs Lee Hyun soon <foolbabo@gmail.com>
@ 2005-08-18 14:43 ` Robert Treat <xzilla@users.sourceforge.net>
0 siblings, 0 replies; 2+ messages in thread
From: Robert Treat @ 2005-08-18 14:43 UTC (permalink / raw)
To: Lee Hyun soon <foolbabo@gmail.com>; +Cc: pgsql-bugs@postgresql.org
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@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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-08-18 14:43 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-08-17 05:29 pgsql-bugs Lee Hyun soon <foolbabo@gmail.com>
2005-08-18 14:43 ` Robert Treat <xzilla@users.sourceforge.net>
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