Re: Bind Parameter is Too Big - Mailing list pgsql-general

From Tom Lane
Subject Re: Bind Parameter is Too Big
Date
Msg-id 639450.1662065281@sss.pgh.pa.us
Whole thread Raw
In response to Bind Parameter is Too Big  ("Kluzak, Matthew C." <mckluzak@nd.gov>)
List pgsql-general
"Kluzak, Matthew C." <mckluzak@nd.gov> writes:
> I recently updated two comment columns in two tables, both on the Sybase and Postgres sides, from varchar (255) to
varchar(1000).The app can succesfully input data with up to 1000 characters to the updated columns in Postgres. The
generatedSQL statement files can insert the data into the first Sybase database, the data successfully pipes to the
masterSybase database, and then successfully pipes that to the other Sybase database . However, when trying to pipe the
datafrom Sybase to Postgres I get the error "Bind Parameter for value :9 is Too Big (2000)." The comment column is the
9thcolumn. 

There is no such string in the Postgres source code (it doesn't even
meet our message style guidelines).  So this is certainly not coming
from the Postgres server.  You didn't specify what's the software
stack on the client side, but it has to be coming from one or another
layer there.

            regards, tom lane



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Bind Parameter is Too Big
Next
From: "Kluzak, Matthew C."
Date:
Subject: RE: Bind Parameter is Too Big