Mario564 Comments - Answer Overflow

If you want to change the search_path, you could run db.execute(sql/* query to set the search path */) right after you'd initialized the connection

5 replies

DTDrizzle Team

•Created by EagleEyes on 9/3/2024 in #help

PostGIS in a separate schema

Drizzle doesn't support having extensions in another schema. However, in the generated migration file you can add the schema prefix manually (like col1 extensions_schema.geometry). For functions, you'd have to use the sql operator to also prefix them with the schema.

5 replies

DTDrizzle Team

•Created by Tomathy on 9/2/2024 in #help

No overload matches this call

You might get a type error with faker.number.int({min: 0, max: 2}), in that case you can just cast:

client_activity[faker.number.int({min: 0, max: 2}) as keyof client_activity]

client_activity[faker.number.int({min: 0, max: 2}) as keyof client_activity]

12 replies

DTDrizzle Team

•Created by Tomathy on 9/2/2024 in #help

No overload matches this call

You can do something like this:

const client_activity = ['ATIVO', 'NÃO ATIVO', 'SUSPENSO'] as const;
const activityEnum = pgEnum(/* Enum name */, client_activity);

const client_activity = ['ATIVO', 'NÃO ATIVO', 'SUSPENSO'] as const;
const activityEnum = pgEnum(/* Enum name */, client_activity);

12 replies

DTDrizzle Team

•Created by Tomathy on 9/2/2024 in #help

No overload matches this call

In the insert statement I see this:

activity: client_activity[faker.number.int({min: 0, max: 2})],

activity: client_activity[faker.number.int({min: 0, max: 2})],

My guess is that client_activity[faker.number.int({min: 0, max: 2})] returns type string instead of the exact type the enum is looking for

12 replies

DTDrizzle Team

•Created by Tomathy on 9/2/2024 in #help

No overload matches this call

I think it might have to do with one of the two enum fields

12 replies

DTDrizzle Team

•Created by Tomathy on 9/2/2024 in #help

No overload matches this call

Just to confirm that the bytea type isn't causing issues, can you change the data attribute to string and see if there's still type errors?

12 replies

DTDrizzle Team

•Created by Tomathy on 9/2/2024 in #help

No overload matches this call

I see a bytea type that isn't part of Drizzle. I assume that's a custom type, what's the definition for that type?

12 replies

DTDrizzle Team

•Created by Tomathy on 9/2/2024 in #help

No overload matches this call

@Tomathy Are you using a monorepo?

12 replies

DTDrizzle Team

•Created by Don Cezar on 9/2/2024 in #help

Drizzle Studio stuck at 'connecting to localhost:4983'

CC: @⚡Z.E.U.S⚡

71 replies

DTDrizzle Team

•Created by Don Cezar on 9/2/2024 in #help

Drizzle Studio stuck at 'connecting to localhost:4983'

I don't specialize in the Studio related stuff so I'll forward this to someone else who is. I've seen some similar complaints but can't seem to find a definitive answer

71 replies

DTDrizzle Team

•Created by Don Cezar on 9/2/2024 in #help

Drizzle Studio stuck at 'connecting to localhost:4983'

Yeah, you follow the same steps mentioned in the guide

71 replies

DTDrizzle Team

•Created by Don Cezar on 9/2/2024 in #help

Drizzle Studio stuck at 'connecting to localhost:4983'

I did this in Win 11, but don't know if Studio running on a Linux OS changes anything

71 replies

DTDrizzle Team