Turn RAISE NOTICE to function calls

cybertec-postgresql / ora_migrator

Tools for Oracle to PostgreSQL migration

Other

109 stars 31 forks source link

Turn RAISE NOTICE to function calls #14

Closed postgresql007 closed 5 years ago

postgresql007 commented 5 years ago

Currently we do RAISE NOTICE to fire out log. Can we send logs into a table AND do a RAISE NOTICE? it is easier for UI people to visualize.

laurenz commented 5 years ago

I have decided only to use a temporary table and I only log the errors that happen during migration. Any tool that calls ora_migrator will probably not call oracle_migrate, but rather the indicidual functions, so it knows which step is currently being performed.