Oddity with DBD::Pg

Any fixes or suggestions for further
investigation of this situation would be
appreciated.

I'm using some code to generate an insert
statement from a hash of ( field => value ).
The fields are taken from keys %argz, the
placeholders from ( '?' ) x @fieldz.

Turning on tracing of the SQL gives me:


BioDB::Database::execute_insert_returning(/sandbox/lembark/Bio-DB/inwork/lib/BioDB/Database.pm:205):
    205:        $sth->trace( 'SQL' );


                       DB<1>

BioDB::Database::execute_insert_returning(/sandbox/lembark/Bio-DB/inwork/lib/BioDB/Database.pm:207):
    207:        $sth->execute( @_ );


                       DB<1>
    PREPARE dbdpg_p22364_7 AS
                insert into type
                ( publish,name,dataset_id,ontology_id )
                values
                ( $1,$2,$3,$4 )
                returning
                type_id
            ;

    EXECUTE dbdpg_p22364_7 (
    $1: 2009-03-11 13:20:20
    $2: GenBank_hidden_flag
    $3: 2
    $4: 3
    );

So far, so good: this *is* the SQL and those are
the correct arguments.

Catch: execute fails with:

    DBD::Pg::st execute failed: ERROR:  Perl hash contains
    nonexistent column "fact_type_id" at
    /sandbox/lembark/Bio-DB/inwork/lib/BioDB/Database.pm line
    207.  at
    /sandbox/lembark/Bio-DB/inwork/lib/BioDB/Database.pm line 207

Indeed, "fact_type_id" is not in the type table, but
is also is not in the SQL!

Using "prepare" instead of "prepare_cached" gave the
same result.

Identically-generated copies of this SQL run just fine
in other places of the code.

Aside: dbd-pg is not on the perl.org mailing list database.
Where is the subscription page?

thanx


-- 
Steven Lembark                                            85-09 90th St.
Workhorse Computing                                 Woodhaven, NY, 11421
[email protected]                                      +1 888 359 3508