Forum OpenACS Q&A: Re: cronjob error: handle "0or1row" is not of type "PostgreSQL"

Yes, you are correct. When we call our oracle database we have to use the -dbn option, Example:

    db_1row -dbn xx1 check_closed {
        SELECT ...
    }

When we query postgres we never use the -dbn parameter:

set asof_date [db_string noxql {SELECT current_date;}]

I believe we have seen it happen on these simple types of queries before. But again it has been hard to debug