Re: Bind Parameter is Too Big

"Kluzak, Matthew C." <mckluzak(at)nd(dot)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 generated SQL statement files can insert the data into the first Sybase database, the data successfully pipes to the master Sybase database, and then successfully pipes that to the other Sybase database . However, when trying to pipe the data from Sybase to Postgres I get the error "Bind Parameter for value :9 is Too Big (2000)." The comment column is the 9th column.

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