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

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@sfi.dk]
> Sendt:    5. juli 2001 14:48
> Til:    'harrold@sage.che.pitt.edu '
> Cc:    'pgsql-novice@postgresql.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@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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html