Artamiel Comments - Answer Overflow

Hi, newbie trying to help The error message that you get indicates that there's no unique constraint placed on the column on the database level Can you check your table structure and make sure that unique constraints index is placed on those columns ?

3 replies

DTDrizzle Team

•Created by n00ki on 5/26/2024 in #help

Properly inferring Prepared Statement Return Type when executing a query

Hi, newbie here just trying to help based on the docs, I believe the prepared statement should be executed with .execute() instead of .all() may I know why did you use .execute on the getAccount but .all on the .getAllAccounts ?

3 replies

DTDrizzle Team

•Created by Robin on 5/27/2024 in #help

DB-Caching?

I believe theres no such thing as caching, especially the one that return data from a dropped database can you share what version you are using and the code snippet too if possible, else it would be hard to debug your issue

2 replies

DTDrizzle Team

•Created by taky0n on 5/28/2024 in #help

"where" clause not found in "with" object

7 replies

DTDrizzle Team

•Created by Kalak on 5/27/2024 in #help

truncate table in drizzle-orm

I believe sql.raw is the only answer as of now

2 replies

DTDrizzle Team

•Created by Tobias on 5/23/2024 in #help

Two tables that references each other

You need to cast the reference using the ‘AnyPgColumn’ for example: ‘’’ table_2_ref: uuid("table_1_ref").references((): AnyPgColumn => table_2.id) ‘’’ more details: https://orm.drizzle.team/docs/indexes-constraints

3 replies

Gaming

Programming