Error on linking remote tables


#1

Hello!

When I’m trying to link virtuoso to remote PostgreSQL tables I’m receiving error 22005 SR130: Integer 140045998620927 does not fit in column COL_PREC.

Where can I read additional information about this problem? What are restrictions on linked data?

Thank you!


#2

Those error i have when linking varchar\int4 postgresql table…

nalog.vk 22005 SR130: Integer 140045998620927 does not fit in column COL_PREC.


#3

@kol9313: Please provide the following information:

  1. What PostgreSQL ODBC Driver are you using?

  2. What is the schema definition of the PostgreSQL table you are attempting to link into Virtuoso, as I can link tables with int4 and varchar columns into Virtuoso without a problem using the OpenLink PostgreSQL ODBC Driver?

  3. At what point in the linking process is the error occurring?

  4. A Virtuoso trace_on() log so we can see the calls being made in Virtuoso and a PostgreSQL ODBC Driver trace log so we can see the ODBC calls being made to the Postgres database, for analysis.