Compatibility Issue with CockroachDB and Effect's Migrator Using LOCK TABLE
We're looking at adopting CockroachDB, which is mostly compatible with Postgres. We've found that the Migrator isn't compatible, however, as it uses
I don't know enough about CockroachDB to know if not including this is safe or whether another approach is needed, but the former would be worth trying (from what I can understand, this is the same as https://github.com/npgsql/npgsql/issues/6025). What would be the easiest way to prevent this command? Have an option somewhere, or a full-blown CockroachDB dialect?
LOCK TABLE when using @effect/sql-pg. It was a bit unexpected to find dialect-specific behaviour in @effect/sql rather than in @effect/sql-pg etc.I don't know enough about CockroachDB to know if not including this is safe or whether another approach is needed, but the former would be worth trying (from what I can understand, this is the same as https://github.com/npgsql/npgsql/issues/6025). What would be the easiest way to prevent this command? Have an option somewhere, or a full-blown CockroachDB dialect?
