RE: Only 350 inserts(should be1000) at a time to postpgr es(or mysql) using odbc(win) ... - Mailing list pgsql-novice

From Kristensen Poul
Subject RE: Only 350 inserts(should be1000) at a time to postpgr es(or mysql) using odbc(win) ...
Date
Msg-id A361159339E0D211AA400000EE71C94BA93BB0@comsrv
Whole thread Raw
List pgsql-novice
Hi,

It seems to be the comma's in text fields that causes the insert problem
e. g   'my address, nr. 11'.

Does it sound possible? and what can I do to solve the problem?

When only numeric values is used everything is done succesfully.

TIA
Poul




-----Original Message-----
From: harrold@sage.che.pitt.edu
To: Kristensen Poul
Cc: 'pgsql-novice@postgresql.org'
Sent: 7/2/01 4:48 PM
Subject: Re: [NOVICE] Only 350 inserts(should be1000) at a time to
postpgres(or mysql)  using odbc(win) ...

if you get the same result with mysql and postgres i would think it's a
programming/frontend issue. can you describe in more detail what is
going
on?

--
john

Sometime in July Kristensen Poul assaulted keyboard and produced...

|
|Does anyone know why the database insert's stops at 350 observations?
|
|I don't get eny arrors.
|
|I get the sam result using mysql.
|
|Can anyone help?
|
|TIA
|
|Poul
|
|The Danish National Institute of Social Research.
|
|
|---------------------------(end of
broadcast)---------------------------
|TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org
|


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

pgsql-novice by date:

Previous
From: Nabil Sayegh
Date:
Subject: Re: User Management
Next
From: Kristensen Poul
Date:
Subject: SV: Only 350 inserts(should be1000) at a time to postpgr es(or mysql) using odbc(win) ...