dbmate dump against cockroachdb failed

[andyli]

$ dbmate dump
Error: pg_dump: error: query failed: ERROR:  column "x.tableoid" does not exist
pg_dump: error: query was: SELECT x.tableoid, x.oid, x.extname, n.nspname, x.extrelocatable, x.extversion, x.extconfig, x.extcondition FROM pg_extension x JOIN pg_namespace n ON n.oid = x.extnamespace

The mentioned query ran fine without selecting x.tableoid. Not sure whether the remaining queries will succeed or not.

My CockroachDB version: CockroachDB CCL v21.2.6 (x86_64-unknown-linux-gnu, built 2022/02/22 18:30:37, go1.16.6)

Maybe dbmate should make use of SHOW CREATE ALL TABLES when it detects the db is CockroachDB.

[rohitpaulk]

Related: https://github.com/cockroachdb/cockroach/issues/20296

[amacneil]

I am going to close this, because it looks like we do not support CockroachDB, and I have no plans to add it. If someone would like to submit as PR for this I'm open to it.