Hello,

I've pushed a change to Spacewalk master which calls the
spacewalk-oracle2postgresql script to generate PostgreSQL specific
variants from the original .sql schema upgrade scripts. It means that
for stuff like CREATE TABLE files in common/tables that are processed
using spacewalk-oracle2postgresql for the main schema definition, you
can just copy them to the respective upgrade subdirectory and you
no longer need to create .oracle and .postgresql variants -- they will
be created upon build time.

On the other hand, anything more complex still needs separate .oracle
and .postgresql files. Most notable are ALTER COLUMN upgrades -- this
syntax is not supported by the conversion script at this point ... but
you are welcome to amend the script and then just plain .sql should
work as well.

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat

_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel

Reply via email to