Servoy Forum

Hi to All,

could SomeOne of You resolve this problem?

While importing a solution on servoy 7 I see this error message:

Could not import solution: org.postgresql.util.PSQLException: ERRORE: la precisione di NUMERIC (65531) deve essere compresa fra 1 e 1000
Posizione: 1181

Tanks in advance.

Gianni Pinna

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.

Hi Bernd,
sincerly tank You for Your luminous suggest, that I have seen today.

But there is a problem in the problem.
I hope that You can resolve.
I do not know how to execute Your query in order to see the column that creates the problem: the laptop in wich the source DB was working crashed.
I can connect to anoter lap_top only the old hard_disk with USB cable.
So I don't know if there is a possibility to import the source DB from old hard disk to the new lap_top.
I Know that it can seem a trivial problem: I excuse.
Tanks again and in advance.

Gianni Pinna

Hi Gianni,
I would ask a hardware expert for this task.
Maybe it is possible to start postgres on the old hard_disk from outside, if not a hardware expert could mount the old hard_disk to a new computer and then start it as usual.
As long as the old hard disk did not crash itself that should be possible.

I do not know how to get a postgres DB back when you have only the files left and can not get the original postgres system to run.
It should be possible, but that would be a task for a postgres expert.

Hi Bernd,
tank to Your suggestion I could resolve.

Tank You, humbly.
Happy Easter, Bernd.
Gianni Pinna