UUID Cast error with pg and aws-data-api in kit studio
Using the drizzle kit studio with drizzle, postresql on a AWS Serverless V2 instance, and aws-data-api as provider, is throwing casting error on UUID types.
Is that something we can configure via configuration? Is tehre a way to solve it?
This is the error messages on any action (Update / Delete / ...) "ERROR: operator does not exist: uuid = text; Hint: No operator matches the given name and argument types. You might need to add explicit type casts.; Position: 71; SQLState: 42883"
7 Replies
find a way around this?>
This is bug and will be fixed
running into this as well
Any update on when this will be fixed and does it impact the actual database or just the drizzle
console?
Hey, sorry to bother you. Any updates on this This is the error messages on any action (Update / Delete / ...) "ERROR: operator does not exist: uuid = text; Hint: No operator matches the given name and argument types. You might need to add explicit type casts.; Position: 71; SQLState: 42883". is there anyway to add the cast types to it as a workaround until it is fixed? Thanks for your time.
Hey @g63sol. I will ask developer who worked on this and I will come back with the answer
If you will upgrade to this release versions, still an issue? https://discord.com/channels/1043890932593987624/1235937884956000377/1270046904834719745
@Mykhailo This appears to still be a bug on drizzle-kit 0.24.2