PowerDesigner 反向 PostgreSQL 时 Unable to list the columns. SQLSTATE =22003 的解决方法

PowerDesigner 16.5反向PostgreSQL9.01中 Unable to list the columns. SQLSTATE =22003不良的类型值 short : t解决方法

Database➙Edit Current DBMS… General tab➙PostgreSQL 9.x➙Script➙Objects➙Column➙SqlListQuery

or Tools➙Resource➙DBMS➙PostgreSQL9.x...同上。

replaced column in SELECT:

     c.attnotnull

to:

     CAST(NULLIF(c.attnotnull,false) as VARCHAR(1))

 

 

Similarly in

...Script\Objects\Key\SqlListQuery

replaced column in SELECT:

     x.indisprimary

to:

     CAST(NULLIF(x.indisprimary,false) as VARCHAR(1))