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

From: Kristensen Poul <pok(at)sfi(dot)dk>
To: "'harrold(at)sage(dot)che(dot)pitt(dot)edu '" <harrold(at)sage(dot)che(dot)pitt(dot)edu>
Cc: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: RE: Only 350 inserts(should be1000) at a time to postpgr es(or mysql) using odbc(win) ...
Date: 2001-07-05 12:47:43
Message-ID: A361159339E0D211AA400000EE71C94BA93BB0@comsrv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sage(dot)che(dot)pitt(dot)edu
To: Kristensen Poul
Cc: 'pgsql-novice(at)postgresql(dot)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(at)postgresql(dot)org
|

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

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

Browse pgsql-novice by date

  From Date Subject
Next Message Kristensen Poul 2001-07-05 13:12:12 SV: Only 350 inserts(should be1000) at a time to postpgr es(or mysql) using odbc(win) ...
Previous Message Nabil Sayegh 2001-07-05 11:22:53 Re: User Management