Issues Using RLS with Supabase Through Drizzle
Hi everyone,
Does anyone know how to use RLS with Supabase via Drizzle?
I was really excited to see that it's finally supported, but unfortunately, it’s not working for me. After migrating the table, I added .enableRLS()—this part works fine, and I can see on the Supabase dashboard that RLS is enabled for that table....
Postgres tables with same name but different schema
I have three
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.
The
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.
I'm trying using $count, and it giving me fieldAlias missing. What should I do?
I'm on drizzle-orm 0.36.1 and drizzle-kit 0.28.0.
My schema is something like below. For note, its oversimplified over my project.
```js
export const item = pgTable(...
