Explaining better my problem. All reports our customer use are customizable.
So, when a customer runs a report it just runs all SQLs that are inside that
report, being SQL or Execute Blocks. But because they are completelly
customizable, one customer has 80 reports with 300 Execute Blocks on them
and other one has just 10 reports with 100 execute blocks and they can be
used to different purposes.
I love PostgreSQL...but why are you migrating away from something with this extent of dependency on Firebird?
I'd probably be trying to figure out some kind of hybrid platform here and not a clean cut-over.
David J.