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
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) ... |