import foreign schema in test does not generate datatypes

gleu / sqlite_fdw

Foreign Data Wrapper for sqlite

Other

34 stars 5 forks source link

import foreign schema in test does not generate datatypes #9

Open wibrt opened 6 years ago

wibrt commented 6 years ago

Hallo,

the code generated by import foreign schema only generates the headers, not the datatypes.

CREATE FOREIGN TABLE public.vrijetijdextra ( "1" , ... "J1_6" ) ..

Can anyone confirm this?

wibrt commented 6 years ago

apparently this occurs with tables that were created with columns without a datatype.

this should be possible?
after creation sqlite considers them to of the general datatype text, but doenst pass this information along

gleu commented 6 years ago

Hi,

Sorry for the very late answer. I didn't know you could have columns without specifying the datatype. But I've checked, and you're right. It definitely looks like they are supposed to be textual columns. I'll fix this.

Thanks.

gleu commented 6 years ago

I've pushed a fix. It works on my sqlite database, but could you test it and report back? Thanks.