Subject: Re: [HACKERS] Packages: Again
2017-01-11 20:42 GMT+01:00 Bruce Momjian <[email protected]
On Wed, Jan 11, 2017 at 08:32:53PM +0100, Pavel Stehule wrote:
> Now I work on migration about 500K rows - and it is terrible work. It is 20
> years old project - lot of code is not clean, It is hard to migrate, it is hard
> to clean. Sure, there is not one line of tests.
> If we miss some, then it is modern robust tool for migration - big thanks to
> ora2pg maintainers and developers - without it, there is nothing free.
I think we need to focus on things that _can't_ be done first, rather
than things that require porting, e.g. until we had savepoints, you
couldn't migrate an application that needed it. It wasn't a question of
porting --- there was just no way to port it.
Those _missing_ pieces should be a priority.
There are some workarounds for emulation of package variables - and I am pressing a design of session variables that can be well used like package variables.
Currently almost all basic functionality (related to PL/SQL) is available in Postgres. But the migration needs lot of hard manual work.
It is analogy with Cobol systems - some applications are too ugly so more level emulation is cheaper solution, than migration to some modern :)
Bruce Momjian <[email protected]
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +