BUG #4481: Big text insert/update using functions failed

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

Responses

Browse pgsql-bugs by date

  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