Ian Summers wrote:
> Is there a way to insert LONG data into Pg?
Can you give us some more details? There is no thing as a LONG datatype
in PostgreSQL.
--
Alessio F. Bragadini[EMAIL PROTECTED]
APL Financial Services http://village.albourne.com
Nicosia, Cyprus
a) check if you have nulls in the data. If you do, you must use type
'bytea' and SQL_BINARY to bind to it.
b) Postgres prior to 7.0 had a limit of 4096 bytes per tuple. Tuple header
takes around 50 bytes, so if you had any other fields, you'd be screwed.
Upgrade to latest.
On Thu, 12 Jul 2001, I
Alessio
Thank you for your reply - I'm trying to insert data with up to 4000
characters in a single column.
Can you have columns defined to allow 4000 characters? More to the point,
can you insert data into them with DBI::Pg?
The code that produces an error looks like this (trimmed to the bar
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
Hi
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 i