How to reconcile local schema with a remote schema that has an extension?
Hello!
I have a database that I installed the postgis extension on. It added some views and tables that do not exist in my local schema so I've attempted a drizzle-kit pull to pull down the remote schema and have parity.
It "fails" and gives this error but does seem to pull down the remote schema.
The remote schema it pulls has "unknown" column types for the extension views and it does not let me perform a db:push with it.
Trying to do a db:push with my current local schema fails because it attempts to truncate the extension views, which the extension requires.
I can drop the extension, and all related tables, but that seems very extreme especially since I'll just have to add it right back.
Is there some way to get the correct table/view definitions for the extension so that my db:push doesn't attempt to truncate needlessly?
I have a database that I installed the postgis extension on. It added some views and tables that do not exist in my local schema so I've attempted a drizzle-kit pull to pull down the remote schema and have parity.
It "fails" and gives this error but does seem to pull down the remote schema.
The remote schema it pulls has "unknown" column types for the extension views and it does not let me perform a db:push with it.
Trying to do a db:push with my current local schema fails because it attempts to truncate the extension views, which the extension requires.
I can drop the extension, and all related tables, but that seems very extreme especially since I'll just have to add it right back.
Is there some way to get the correct table/view definitions for the extension so that my db:push doesn't attempt to truncate needlessly?
