Izaan
DTDrizzle Team
•Created by Izaan on 1/3/2024 in #help
Error: unknown error: Code: UNAVAILABLEserver does not allow insecure connections, client must use
1 replies
DTDrizzle Team
•Created by Izaan on 12/16/2023 in #help
how do I store list of string in my pg table
I want to store a list of user ids in my table with currently I am doing this
editors:text("editors").array().references(() => users.id, { onDelete: "cascade",}),
which is giving me this error error: foreign key constraint "youtube_channel_editors_user_id_fk" cannot be implemented
Detailed error => detail: 'Key columns "editors" and "id" are of incompatible types: text[] and text.', where: 'SQL statement "ALTER TABLE "youtube_channel" ADD CONSTRAINT "youtube_channel_editors_user_id_fk" FOREIGN KEY ("editors") REFERENCES "user"("id") ON DELETE cascade ON UPDATE no action"\n' + 'PL/pgSQL function inline_code_block line 2 at SQL statement'
6 replies
DTDrizzle Team
•Created by Izaan on 12/8/2023 in #help
self reference error
I have just started to learn drizzle and was stuck on some problem
and I get this error =>
'users' implicitly has type 'any' because it does not have a type annotation and is referenced directly or indirectly in its own initializer.ts(7022)
const users: any
also when i query my db why do I not get type completions on the returned object.20 replies