Thread: SV: Only 350 inserts(should be1000) at a time to postpgr es(or mysql) using odbc(win) ...
SV: Only 350 inserts(should be1000) at a time to postpgr es(or mysql) using odbc(win) ...
From
Kristensen Poul
Date:
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