Hello, we know that PostGreSQL is not a supported database but one of our customer ask us to develop an application with this target database. We thought that using odbc or jdbc we can try to use it. We tried to develop some entities and Plex compiles the tables and the views. So we hope that all works correctly (now we tried to use configuration using Winc and NTODBC Server). The problems appears when we tried to read the table using BlockFetch and Checkrow, or SingleFetch. Because the query we receive on the postgres db are added of a field named "ctid" that is not present in the views that Plex generate. The field that is an internal field of a postgres table exist and if we make the query included this field on a table it works correctly but it doesn't work on a query on the view, because the field is not included in the view. The strange fact is that BlockFetch add this field byself. We don't understand why.
We have solved the problem using the triple VW type sys Table_access, but we think may be a limitation.