[Postgres] PostgresError: type X already exists.
PostgresError: type "media_types" already exists
PostgresError: type "media_types" already exists
CREATE TYPE "public"."media_types" AS ENUM('image', 'video');--> sta
...Drizzle-kit not working as expected
Postgres tables with same name but different schema
users
tables, each in different postgres schema. They have 3 columns in common: email, createdAt and updatedAt. When I try to make a relational query where I fetch a token with the user relation, the type of the user contains just those 3 columns, instead of all columns of that specific users table (image attached). Seems like it is an intersection of the types of those 3 users. Seems like the problem is that a relation is defined as:
```
Relations<"users", {
...
}>...
The signature with pgTable is depreciated.
pgTable
function with the callback function is depreciated? And If i remove the second argument to the function(the callback function), the depreciation message disappears.
is it possible for a join table to have one of the relations reference a composite key?
Can't migrate with pgPolicy and pgRoles
Supabase SSL - ENAMETOOLONG when adding sslrootcert to dbCredentials url
I'm trying using $count, and it giving me fieldAlias missing. What should I do?

Can i use "uniqueIndex" for that?
TypeError: db.execute is not a function
Automatically convert binary to string
Drizzle-kit push - pgPolicy ignores using configuration
column is of type date but expression is of type text
column \"date_of_birth\" is of type date but expression is of type text
column \"date_of_birth\" is of type date but expression is of type text
Do prepared statement names matter?
Bun:SQLITE error with drizzle
How do I get types for relationship queries?
Filter based on join data
<student>.coach.fullname
where coach is added as a with
join. I would like to get every student that have a certain coach.Using relation columns in where clause (Drizzle playground provided)
column agent.deleted does not exist
. Why can't you reference relation columns in a top-level where clause? Is there a better way to do this without using the select
API with joins?...StatementTimeoutException: Request timed out