Hi ,
We’ve noticed when adding a number field to a table in Servoy we get a single precision field in the PostgreSQL table NUMBER(4) / REAL.
We were used to double precision with Sybase.
Is this a bug ?
Regards,
Lambert,
This is indeed a difference in the postgres dialect as defined by Hibernate.
Please file a case in our support system so we can investigate.
Rob
Hi Rob,
My colleague did already : case 316304.
FYI : When creating a postgreSQL table from the servoy dbi file we get double precision with a number field
Regards,
That is because the dbi file contained the sql type double as reported by the old sybase driver.
This value is mapped by the postgres dialect to a double precision type, however the number type in Servoy is float (single precision).
In Servoy 5.2.2 we will change the mapping for postgres to double precision for the Servoy number type, so number columns created with the table editor will be created with double precision in postgres.
Rob
Thanks Rob,
I think we’ll survive on this one till that time (5.2.2)
PS I’m glad Servoy has internally the ability to distinguish between single and double precision.
I think we as developers can’t choose between single and double from within the table editor.
What I enter in the width of the number field does not seem to have any effect and is replaced with the initial value when I open the table editor again…
Regards,