Обсуждение: strange error

Hello,

I try to copy a file into a database :
    On our main server (postgresql 8.1 debian etch ia64) no problem.
    On a test laptop (postgresql 8.2 debian testing lenny ia32) I
receive the error :
      the size of the array exceed the maximum allowed (268435455)

db_stats=# COPY table_cat FROM '/var/lib/postgresql/scripts/cat_sql.out'
WITH DELIMITER ';';
ERREUR:  la taille du tableau dépasse le maximum permis (268435455)
db_stats=#

Could you help me ?

Thanks in advance

Guy

Hello

I match the problem : a trigger writed in PL::Ruby
If I remove the trigger ok.
but I don't know how fix it.


De Leeuw Guy a écrit :
> Hello,
>
> I try to copy a file into a database :
>     On our main server (postgresql 8.1 debian etch ia64) no problem.
>     On a test laptop (postgresql 8.2 debian testing lenny ia32) I
> receive the error :
>       the size of the array exceed the maximum allowed (268435455)
>
> db_stats=# COPY table_cat FROM '/var/lib/postgresql/scripts/cat_sql.out'
> WITH DELIMITER ';';
> ERREUR:  la taille du tableau dépasse le maximum permis (268435455)
> db_stats=#
>
> Could you help me ?
>
> Thanks in advance
>
> Guy
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>