| Lists: | pgsql-bugs |
|---|
| From: | "TONY J(dot)Y(dot)" <tjiang(at)mrf(dot)com> |
|---|---|
| To: | <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Bug report. |
| Date: | 2001-11-27 15:39:01 |
| Message-ID: | 000a01c17759$a3608150a01a8c0@Aqua.MRF |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
Hi,
I am using the PGLIB C lib to connect to PgSql to finish the update of
the GEOMETRY of a table.
At first, everything is OK. I can insert, update, delete and select of
whatever I want.
However, I got a fatal running error. There is an error when my SQL
string length exceeds 8190 Bytes.
Obviously, this is not the limits of the PgSQL itsself when using psql.
It is the PGLIB, isn't it?
Is there any solution or suggestion?
Thanks.
Best regards,
Tony
---
Tony Jiang, MSc
Research & Development Programmer/Analyst
MRF Geosystems Corp (www.mrf.com)
Suite 700, 665 8th Street SW,
Calgary, AB T2P 3K7
(403) 216-5515 ext:226
| From: | Markus Bertheau <twanger(at)bluetwanger(dot)de> |
|---|---|
| To: | "TONY J(dot)Y(dot)" <tjiang(at)mrf(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Bug report. |
| Date: | 2001-11-28 13:49:34 |
| Message-ID: | 1006955375.4552.43.camel@entwicklung01.cenes.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
On Tue, 2001-11-27 at 16:39, TONY J.Y. wrote:
> However, I got a fatal running error. There is an error when my SQL
> string length exceeds 8190 Bytes.
PostgreSQL 7.0.x and earlier have a restriction of 8k for a text field.
7.1.x doesn't. You should upgrade.
Markus Bertheau