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 +

Programming list archiving by: Enterprise Git Hosting