11 Replies Latest reply on Aug 31, 2017 6:27 AM by Ramesh Reddy

    UUID type in Postgresql

    Lukáš Svačina Newbie

      Hi,

      i'm trying to find out how to teach Postgresql datasource translator to work correctly with UUID datatype. Teiid sees it as Object instead of, for example, String datatype. It causes one can't do any ordering/where in sql queries.
      One way is to make view with manual CASTing UUID datatype. It is not suitable for dynamic VDB generation.

       

      <metadata type="DDL">

      <![CDATA[

      CREATE VIEW "_view_workflow_data" OPTIONS (UPDATABLE 'true') AS

      SELECT

        CAST("lukyer_table"."id" as string) AS "id",

      "id" AS "id_original"

      FROM "lukyer_table"

      ]]>

      </metadata>

       

      What is recommended way how to achieve automatic UUID casting to String? Should i overwrite JDBC translator and implement it somehow there? Is it even possible?

       

      Thanks.