From: | "Julien Vadnais" <jvadnais(at)cybergeneration(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #4481: Big text insert/update using functions failed |
Date: | 2008-10-15 15:50:48 |
Message-ID: | 200810151550.m9FFom25050764@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4481
Logged by: Julien Vadnais
Email address: jvadnais(at)cybergeneration(dot)com
PostgreSQL version: 8.2.5
Operating system: Ubuntu Linux 7.04, Kernel 2.6.20-15-server
Description: Big text insert/update using functions failed
Details:
Our actual configuration:
PostgreSQL(libpq) Version : 8.2.4
Pdo : Module version 1.0.2
PHP : Version 5.2.6
When trying to insert/update long text string into the DB using a pgsql
function, an error occures. (If ~6000 char or more)
We have made several tests and we found that: -Insert/Update using
pg-function and PDO failed
-Insert/Update using PDO without pg-function works
-Insert/Update using pg-function without PDO works
-Insert/Update not using PDO and pg-function works
This error was not occuring before we upgraded from postgresql-8.1.10.
We tryed upgrading to postgresql-8.2.5 and postgresql-8.3.3 but the problem
still occured in both of those versions.
Here is the error we are catching on the DB server:
SSL SYSCALL error: EOF detected
could not receive data from client: Connection reset by peer
unexpected EOF on client connection
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2008-10-15 15:57:14 | Re: BUG #4465: GROUP BY is not to SQL standard |
Previous Message | Tom Lane | 2008-10-15 15:26:50 | Re: Postgres database problem |