No, I don't think that it is a java 1.4 issue, bacause WIAB is running
on 1.4 too.
2003-11-11 18:08:40,260 [ImageConvert] ERROR support.PostgreSQL71 - SQL
: INSERT INTO install_icaches (number, otype, owner, ckey, id, handle,
filesize) VALUES (?, ?, ?, ?, ?, ?, ?)
2003-11-11 18:08:40,261 [ImageConvert] ERROR support.PostgreSQL71 -
SQLState : null
2003-11-11 18:08:40,261 [ImageConvert] ERROR support.PostgreSQL71 -
ErrorCode: 0
2003-11-11 18:08:40,261 [ImageConvert] ERROR support.PostgreSQL71 -
Message : ERROR: ExecAppend: rejected due to CHECK constraint
install_icaches_id_references
All before these log messages are just okay. The error says that it
fails on the check constraint of the number column. There is a function
in your database which looks like this.
CREATE FUNCTION install_check_number (integer)
RETURNS boolean AS
'SELECT CASE WHEN (( SELECT COUNT(*)
FROM install_object
WHERE install_object.number = $1 ) > 0 )
THEN 1::boolean ELSE 0::boolean
END;'
LANGUAGE 'sql';
My suggestion is to set the log level for
org.mmbase.module.database.support to debug to see what the values are
for the preparedstatement. It ccould be that the new number is already
present (the autoicrement sequence is too low) or the function is
broken. It is probably the first one.
Nico
----------------------------------------------------------------------
Hardware: That part of the computer which you can kick
> -----Oorspronkelijk bericht-----
> Van: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Namens Peter van der Meer
> Verzonden: woensdag 12 november 2003 14:57
> Aan: '[EMAIL PROTECTED]'
> Onderwerp: RE: MMbase - PostgreSQL - Images problem
>
>
> Hello Nico,
>
> I use PostgreSQL version 7.2 and my blob is saved in a bytea
> field. Could it be a java 1.4 problem?
>
> Peter van der Meer
>
> Software Developer
> VARA Nieuwe Media
