You are not logged in.
I can't find the way to make something that should be really usual :
I want to import some values in a table of a postgresql database. This table is very simple except the fact that one of its column have a specific type : "type_entite". This is a type i declared in postgres like an enum of ('E','L','M').
In TOS, when i retrieve the table schema with the metadata manger, TOS maps my specific type with a generic type : String.
Well, it doen't really matter to me but the point is that when i try to import my datas (my source is a delimited file) in the table, i get this error :
ERROR: column "code_entite" is of type type_entite but expression is of type character varying
It seems that it tries to convert from string to type_entite but as TOS doesn't know what is type_entite, it crashes. So, my question is : Is there a way to retrieve my personal db types from my database, in order to use them in TOS ?
Last edited by etletisme (2009-04-23 17:56:45)
I am noticing the same behavior. I am unable to load data into tables that have an ENUM field. Talend seems to be casting the input data as varchar, when it should just be sent as a raw SQL string.
I think I will open a bug...