On Thu, Jul 12, 2001 at 11:09:33AM +0100, Ian Summers wrote:
>
> Can anyone enlighten me? I'm trying to insert a field with 4000 characters
> into a Pg database which is specified as varchar(4000).
>
> I've overcome various hurdles but it produces the following error as soon
> as it encounters the LONG field:
>
> DBD::Pg::st execute failed: PQsendQuery() -- There is no connection to the
> backend.
What versions are you using? DBD::Pg before 0.96 had a long insert bug.
Latest is 1.01 . There are a few other bits and pieces that have been
fixed too so it's worth installing 1.01 .
> p307: TEXT datatype has limit of 4096 - is this true?
I don't have the book to hand but PostgreSQL has no such limit - before
7.1 there was a row limit settable at compile-time but the default was
never smaller than 8 kb.
> Is there a way to insert LONG data into Pg?
In principle there is no problem with what you're trying to do.
Richard
