Forum OpenACS Q&A: Re: ns_ora to ns_pg migration

Collapse
Posted by Jean-Fabrice RABAUTE on
Hi,

thank you for your feedback.
I am not upgrading to 5.x version, just trying to replace oracle by postgresql.

I checked the db_blob_get_file, db_write_blob, etc functions trying to get the basic calls to emulate them without success 😟
I will try to go deeper in the code to find what I need, or use them directly (but I like to understand what I am doing...).

Can you confirm that the openacs 5.x functions "db_blob_get_file, db_write_blob" do not need changes on the db (column name "lob" and triggers etc).
Because I read this page :

http://techdocs.postgresql.org/techdocs/oracle-to-pg-porting.php

(search for "You must use the name")

And that's why I am a littke bit confused...

Thank you very much for your help.