Support xid types in postgres

[enrique-fernandez-polo]

Hello there!

I am using watermill in my project with the SQL It creates a set of tables where the different elements publish and subscribe for events.

Watermill can create the tables for you but I prefer to have all the database changes centralized using the same tool.

One of the types that watermill uses is xid8. I've tried

type = sql("xid8")

Is it possible to create a table with this type? Do I have to wait for this type to be supported?

Thanks in advance!

[a8m]

Hey, @enrique-fernandez-polo

As mentioned in #2769, there is no special handling for each external/user-defined type. You should use sql(…) for any type that is not supported by the HCL syntax.

[enrique-fernandez-polo]

Hello!

Then I guess the error Error: create table "watermill_deployments": postgres: unsupported type: "xid8" Comes from the postgres instance not atlas?

[enrique-fernandez-polo]

I am confused with this issue. I get the error generating the migrations if use hcl syntax and sql syntaxt but If I connect to the database I can execute the SQL query to create the table.

table "test" {
  column "transaction_id" {
    type = sql("xid8")
  }
}

create table "test"
(
  transaction_id xid8 not null
)

If I execute the create table in the database I do not get any error.