[Postgres] schema command fails: error: sql: Scan error on column index 1, name "enumsortorder"

[mikestefanello]

Trying to generate a schema with xo for the first time.

$ mkdir -p models
$ xo schema "pgsql://postgres@localhost:5432/dev?sslmode=disable"

error: sql: Scan error on column index 1, name "enumsortorder": converting driver.Value type float64 ("34.5") to a int: invalid syntax

[hhhapz]

Hey, thanks for submitting an issue! It's really hard to help debug the problem when we dont have access to the schema :(. If you share more information including a way to reproduce the error, it makes it easier for us to help

[mikestefanello]

I understand. I was hoping to first see if the error made it clear what in the schema would be causing this. I unfortunately cannot share the schema entirely. We're debugging this and will report back with more info. It seems there's a problem with an enum using a non-int value and an index with a conversion.

[mikestefanello]

I can confirm that's the source of this problem - an enum with a non-int value (in this case, it is 34.5).

The other error, which I can open a separate issue for if you'd like, is error: could not find public.table_name index index_name column id 0. It has a conversion on it, ie lower(name).

[mikestefanello]

I created a new issue for the second problem: #345

[mikestefanello]

This was the result of a migration that added a value before another.

IE:

ALTER TYPE t_my_type
    ADD VALUE 'NEW_VALUE' BEFORE 'EXISTING_VALUE';