> Alan, it's blob to blob. The table is the same. I getting from one row
> and inserting in another row (modifying pk, of course). And I forgot
> I'm using FB 1.5 RC3.
> Below the table and the insert statement:
>
> create table releases (
> releaseID objectID not null,
> fileID objectID not null,
> releaseOut boolean not null,
> releaseOutTime timestamp,
> releaseInTime timestamp,
> taskID objectID,
> developerID objectID,
> releaseNum smallint default 1 not null check (releaseNum
> > 0),
> releaseAge timestamp not null,
> releaseCrc integer,
> releaseDescription text not null,
> releaseSource binary not null,
> constraint releasesPK primary key (releaseID)
> );
>
> ...
> insert into releases
> select
> :newReleaseID, :newFileID, 0, null, current_timestamp, null, null, 1,
> releaseAge, releaseCrc, releaseDescription, releaseSource
> from
> releases
> where
> releaseID = :releaseID;
>

What's the domain text? How is it defined? and binary?
Why are you using parameters in the select? Is this how you are running the
query in an admin tool or in your application?

Alan