Skip site navigation (1) Skip section navigation (2)

Truncation Problem

From: <webmaster(at)gustavus(dot)edu>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Truncation Problem
Date: 2001-06-22 14:14:16
Message-ID: 000901c0fb25$9f433f00$5e44ec8a@apoch (view raw or flat)
Thread:
Lists: pgsql-bugs
We are having problems with information we are inserting into our
database being truncated.  This information is being inserted via the
web using ColdFusion 4.0.1's ODBC interface into a PostgreSQL 7.0.2
database.  It is being truncated in a couple of ways.  Sometimes, after
so many characters, the information is truncated in each column.  Other
times, the information for the last part of the insertion string is
lost.  These insertions usually contain a couple paragraphs of
information for each column.  We haven't had any problem with short
insertions.  Neither ColdFusion or PostgreSQL return an error on a
truncation.  We occasionally will receive a "query string too long"
error from PostgreSQL, but no information is actually inserted into the
database.  The query string error is also confusing because each column
should be able to contain 1+GBs of information.

Has anyone had any similar problems?




-j


pgsql-bugs by date

Next:From: Tom LaneDate: 2001-06-22 14:14:44
Subject: Re: about createdb err
Previous:From: petite-etoile@voila.frDate: 2001-06-22 07:55:57
Subject: Help PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group