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

  • Post author:
  • Post category:其他



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

转载于:https://www.cnblogs.com/ITbbs/p/4441693.html