Google translates: "the precision of NUMERIC (65531) must be between 1 and 1000"
It seems postgres has problems in creating a numeric field.
How did you create the numeric fields in your tables?
The usual way with help of the Servoy table editor, or directly in postgres and then with "Synchronize with DB server..." ?
Are there any "unusual" numeric fields in your tables?
Try
- Code: Select all
SELECT * FROM information_schema.columns
to get all fields of your database and put that into a new temporary table with SELECT INTO...
There is a field "numeric_precision" in that table.
Sort the complete table by that field und you might see the column that creates the problem.
- num.png (44.04 KiB) Viewed 5692 times