You are viewing a plain text version of this content. The canonical link for it is here.
Posted to embperl@perl.apache.org by Robert <ro...@robert.cz> on 2003/06/30 14:59:38 UTC

Recordset: make test error with latest Postgres

Hi,

  Recordset make test fails with Postgres 7.3 on 'select multiple fields 
2', error log attached. It used to work before, it seems Postgres' type 
convertion rules are more restrictive... In error log Recordset says 
'bind_types=1 4'  and then Postgres complaints about atoi - new version 
of Postgres wouldn't accept empty string for integer field... could this 
be the reason?

- Robert
 

Re: Recordset: make test error with latest Postgres

Posted by Robert <ro...@robert.cz>.
Gerald Richter wrote:

>>  Recordset make test fails with Postgres 7.3 on 'select multiple fields
>>2', error log attached. It used to work before, it seems Postgres' type
>>convertion rules are more restrictive... In error log Recordset says
>>'bind_types=1 4'  and then Postgres complaints about atoi - new version
>>of Postgres wouldn't accept empty string for integer field... could this
>>be the reason?
>>    
>>
>
>Yes, seems so. Go to Compat.pm and tell it that 4 is a numeric type. This
>should fix the problem
>  
>
I did the trick, now make test pass all test with success. Thanks.

- Robert


---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org


Re: Recordset: make test error with latest Postgres

Posted by Gerald Richter <ri...@ecos.de>.
>
>   Recordset make test fails with Postgres 7.3 on 'select multiple fields
> 2', error log attached. It used to work before, it seems Postgres' type
> convertion rules are more restrictive... In error log Recordset says
> 'bind_types=1 4'  and then Postgres complaints about atoi - new version
> of Postgres wouldn't accept empty string for integer field... could this
> be the reason?
>

Yes, seems so. Go to Compat.pm and tell it that 4 is a numeric type. This
should fix the problem

Gerald


---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org