Moving application from solid to postgresql

Hi Dominique,

The main thing I remember from a quick test with a small demo application is that Postgresql returns rows in a fairly random order if you don't have an "order by" clause in your read statements, so I would add those in advance.

Other than that, the effort will obviously depend upon the amount of direct SQL you have in your code (SQL & read where clauses) + stored procedures & triggers. My app used database-independent read u_where/selectdb statements, so it was relatively easy.

From experience of other database migrations (not Postgres) i'd also check for differences in behaviour when database contraints and triggers occur, and consider overflow tables and data type mapping when migrating data (Uniface exports cover this, but if using external tools due to large volumes of data you may need to make sure this is covered).

Kind Regards,

David