Specifically - PDI 8.0 CE using PostgreSQL and driver version 42.2.2, I need to specify the option of `stringtype=unspecified`. This is used to avoid casting issues from varchar to uuid.
Related background: ERROR: column "guid" is of type uuid but expression is of type character varying
If I switch from JNDI to JDBC in my connection type this option is used. I do not think it is when using JNDI.
Any help is greatly appreciated, thanks in advance.