plugins-workspace icon indicating copy to clipboard operation
plugins-workspace copied to clipboard

[sql] unsupported datatype: UUID

Open KauanCurbani opened this issue 1 year ago • 3 comments

When I sent a query to my Postgres database, this error was returned, but it is common to use this type in Postgres

image image

KauanCurbani avatar Mar 28 '24 20:03 KauanCurbani

I've got unsupported datatype: NUMERIC in postgres. Seems like there should be a quick way to add these in userland

cmmartin avatar Apr 13 '24 05:04 cmmartin

Seems like there should be a quick way to add these in userland

That'd be hard or impossible (at least with how the SQLx crate currently works) because the queries happen in rust so the database types have to be mapped to rust types and then to json compatible types so that they can be sent back to js. I don't think we'll ever cover all types the db supports, but you can always open an issue about a missing (if there's none already) and we can take a look.

FabianLars avatar Jun 17 '24 16:06 FabianLars

Yeah. When I wrote that, I actually meant in rust when I said "userland". But I've since realized that's kind of silly because the whole point of this plugin is you don't have to write rust

cmmartin avatar Jun 18 '24 21:06 cmmartin