Menu

#1174 PostgreSQL: create table script: wrong data type numeric

All
closed-accepted
nobody
Postgresql (3)
5
2015-01-20
2015-01-19
No

Create a table like

create table t(
value numeric(5, 2)
);

Then, use 'Scripts - Create Table Script', you get:

CREATE TABLE "mySchema"."t"
(
value numeric(19)
)
;

There is a bug with numeric data types. In the created script you find 'numeric(19)' instead of 'numeric(5, 2)'.

Discussion

  • Andy Schönemann

    This affects at least versions 3.6 and 3.5.3.

     
  • Gerd Wagner

    Gerd Wagner - 2015-01-20

    Fixed in our Git repository. Will be fixed in future snapshots and versions.

     
  • Gerd Wagner

    Gerd Wagner - 2015-01-20
    • status: open --> closed-accepted
     

Log in to post a comment.