SV: 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: SV: Only 350 inserts(should be1000) at a time to postpgr es(or mysql) using odbc(win) ...
Date: 2001-07-05 13:12:12
Message-ID: A361159339E0D211AA400000EE71C94BA93BB2@comsrv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Very sorry having takne your time.

The comma's is not at problem.

I will get back when resolved.

Very sorry.

Regards Poul

> -----Oprindelig meddelelse-----
> Fra: Kristensen Poul [SMTP:pok(at)sfi(dot)dk]
> Sendt: 5. juli 2001 14:48
> Til: 'harrold(at)sage(dot)che(dot)pitt(dot)edu '
> Cc: 'pgsql-novice(at)postgresql(dot)org'
> Emne: RE: [NOVICE] Only 350 inserts(should be1000) at a time to postpgr
> es(or mysql) using odbc(win) ...
>
> 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
>
[Kristensen Poul] very sorry having bodered you.

>
>

> -----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
>
> ---------------------------(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 R Vijayanath 2001-07-05 15:33:04 can we write to a flat file from Postgresql procedure
Previous Message Kristensen Poul 2001-07-05 12:47:43 RE: Only 350 inserts(should be1000) at a time to postpgr es(or mysql) using odbc(win) ...