Schema filter not working
As can been seen in the pic I have provided the filter but when i run the drizzle-kit introspect command it still does not take filter the schema
![No description](https://cdn.answeroverflow.com/1263501087911186453/Screenshot_2024-07-18_at_16.22.05.png)
12 Replies
👋 the 15 fetched tables are not in the
public
schema?@rphlmr âš¡ so basically its fetching too much. So for example its pulling enums from other schemas
Looks like the same issue https://github.com/drizzle-team/drizzle-kit-mirror/issues/407
GitHub
introspect schemaFilter doesn't work for data types · Issue #407 · ...
I'm filtering out a schema using schemaFilter in the config. It seems to work for everything except data types - it's still including those from the filtered out schema. drizzle-kit version...
@rphlmr âš¡ ok. I mean its not hurting so I am fine with that. But I am using supabase auth and as per this discussion https://github.com/supabase/supabase/issues/19883 it should create a a users table for refrencing to the auth schema. const authSchema = pgSchema("auth");
export const Users = authSchema.table("users", {
id: uuid("id").primaryKey(),
}); but its not doing that.
GitHub
When using Supabase Auth, how do you relate to other tables using D...
Improve documentation https://supabase.com/docs/guides/database/connecting-to-postgres#connecting-with-drizzle Describe the problem When using Supabase Auth, how do you relate to other tables using...
Like its creating userInAuth for the relations but that table is not in the schema
![No description](https://cdn.answeroverflow.com/1263514288132329483/Screenshot_2024-07-18_at_17.14.11.png)
I have hacked that in my schema.ts
Not exporting these 2 objects is important. We can use them later in tables without messing up our migrations.
I am also using Supabase for https://drizzle.run
@rphlmr âš¡ thanks!
Last one. So as per this discussion https://discord.com/channels/1043890932593987624/1263501087055413294 gemoetry type should be added when doing introspect if u have the latest version of drizzle.
So actually i have it but still its creating unknown type. Need any extra config?
you mean this? https://orm.drizzle.team/learn/guides/postgis-geometry-point
Drizzle ORM - PostGIS geometry point
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.
I am not sure how it works 😬
@rphlmr âš¡ But as per my understanding. It is only relevant when creating postgis related tables. But I am justing doing the introspect so shouldn't that geometry type be refrenced in the schema.ts by the cli?
@Andrii Sherman I don't know :sweating: , if you have some info about what should be expected here?
it should work actually, so definitely a bug
you still can manually add it to unblock you, but we will fix it