search

tds-fdw / tds_fdw

A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)
Other
377 stars 101 forks source link

Error when importing foreign schema (float data type) #321

Closed vitalca closed 1 year ago

vitalca commented 1 year ago

Issue

Sybase ASE 15.5:

CREATE TABLE dbo.dc_config (
  dc_key varchar(30) NOT NULL,
  dc_int int NULL,
  dc_string varchar(30) NULL,
  dc_float float NULL
);

Postgres 15:

=> IMPORT FOREIGN SCHEMA dbo LIMIT TO (dc_config) FROM SERVER sybase_client01 INTO sybase;

ERROR: precision for type float must be at least 1 bit
1 statement failed.

Version of tds_fdw

2.0.3

Version of PostgreSQL

15.0-1
GeoffMontee commented 1 year ago

PR #324 has been merged, so this has been fixed.

Thanks!