Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Bug: Error with enum type and geography type at Postgres #14

Closed
bungambohlah opened this issue Jul 15, 2022 · 4 comments
Closed

Bug: Error with enum type and geography type at Postgres #14

bungambohlah opened this issue Jul 15, 2022 · 4 comments

Comments

@bungambohlah
Copy link

bungambohlah commented Jul 15, 2022

So, i just install ReadySet at my local with my Postgres 14 existing.

Then, i just want to select my "Table" with specific type like enum or geography.
When i try to query got this error.

ERROR:  internal error: could not retrieve expected column index 3 from row while parsing psql result: error deserializing column 3: cannot convert between the Rust type `noria_data::DataType` and the Postgres type `geography`

this is bug? or i just wrong install

btw, great work for doing this. Keep it up.

@bungambohlah
Copy link
Author

Someone just already drop this same problem and got answer for that, because ReadySet got limited supported types. So, this need to explain at the docs.
Thank you and keep the good work.

@bungambohlah
Copy link
Author

The limited types list:

ReadySet supports the following data types:

  • BOOL
  • CHAR
  • VARCHAR
  • INT
  • INT UNSIGNED
  • BIGINT
  • BIGINT UNSIGNED
  • SMALLINT
  • SMALLINT UNSIGNED
  • BLOB
  • LONGBLOG
  • MEDIUMBLOB
  • TINYBLOB
  • DOUBLE
  • FLOAT
  • REAL
  • NUMERIC
  • TINYTEXT
  • MEDIUMTEXT
  • LONGTEXT
  • TEXT
  • DATE
  • DATETIME
  • TIME
  • TIMESTAMP / TIMESTAMP WITHOUT TIME ZONE
  • TIMESTAMPTZ / TIMESTAMP WITH TIME ZONE
  • BINARY
  • VARBINARY
  • DECIMAL
  • BYTEARRAY
  • BIT
  • VARBIT
  • SERIAL
  • BIGSERIAL

ReadySet additionally has limited support for the following data types:

  • JSON
  • JSONB
  • UUID
  • MACADDR
  • INET

@glittershark
Copy link
Member

@bungambohlah the full list of supported types (and everything else query-support related) is now up at https://docs.readyset.io/using/queries#types

@bungambohlah
Copy link
Author

@glittershark ok noted that, thank you for the updates

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants