https://community.qlik.com/t5/Talend-Studio/TDI-5-4-1-postgresql-and-numeric-type/m-p/2248944#M33636 Hello , <BR />In my postgresql database , i have columns with numeric type , without precision <BR />example : alt_max NUMERIC <BR />When i execute a tPostgresqlOutput composant , i have this message : <BR />Exception in component tPostgresqlOutput_1 <BR />org.postgresql.util.PSQLException: ERREUR: la précision NUMERIC 131089 doit être comprise entre 1 et 1000 <BR /> Position : 97 <BR />( precision NUMERIC must be between 1 and 1000) <BR />How manage this type with Talend ? <BR />Thanks in advance Fri, 28 Mar 2014 10:39:58 GMT jeanphi45 2014-03-28T10:39:58Z https://community.qlik.com/t5/Talend-Studio/TDI-5-4-1-postgresql-and-numeric-type/m-p/2248944#M33636 Hello , <BR />In my postgresql database , i have columns with numeric type , without precision <BR />example : alt_max NUMERIC <BR />When i execute a tPostgresqlOutput composant , i have this message : <BR />Exception in component tPostgresqlOutput_1 <BR />org.postgresql.util.PSQLException: ERREUR: la précision NUMERIC 131089 doit être comprise entre 1 et 1000 <BR /> Position : 97 <BR />( precision NUMERIC must be between 1 and 1000) <BR />How manage this type with Talend ? <BR />Thanks in advance Fri, 28 Mar 2014 10:39:58 GMT https://community.qlik.com/t5/Talend-Studio/TDI-5-4-1-postgresql-and-numeric-type/m-p/2248944#M33636 jeanphi45 2014-03-28T10:39:58Z https://community.qlik.com/t5/Talend-Studio/TDI-5-4-1-postgresql-and-numeric-type/m-p/2248945#M33637 Hi, <BR />Here is a related jira issue on Talend Bug Tracker, could you please have a look at it <A href="https://jira.talendforge.org/browse/TDI-13750]" rel="nofollow noopener noreferrer">https://jira.talendforge.org/browse/TDI-13750]</A> to see if it is working with you? <BR />Best regards <BR />Sabrina Mon, 31 Mar 2014 07:48:53 GMT https://community.qlik.com/t5/Talend-Studio/TDI-5-4-1-postgresql-and-numeric-type/m-p/2248945#M33637 Anonymous 2014-03-31T07:48:53Z