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))

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。