Forum OpenACS Development: Posible problem in Evaluation with PostgreSQL?

Collapse
1: Posible problem in Evaluation with PostgreSQL?
Posted by Luis Ig. Bacas on 09/22/08 09:30 AM
Is right the next query?

<fullquery name="cr_write_content.write_lob_content">
      <querytext>
          select lob as content
          from cr_revisions
          where revision_id = :revision_id
      </querytext>
</fullquery>

In Oracle this query is :
    select content
    from cr_revisions
    where revision_id = $revision_id

I seen the query in packages/acs-content-repository/tcl/revision-procs-postgres.xql

Collapse
2: Re: Res: Posible problem in CR with PostgreSQL? (response to 1)
Posted by Luis Ig. Bacas on 09/22/08 09:31 AM
I need more cafeine. I suppose the problem really is in Content Repository Package.