search

cyrilgdn / terraform-provider-postgresql

Terraform PostgreSQL provider
https://www.terraform.io/docs/providers/postgresql/
Mozilla Public License 2.0
376 stars 194 forks source link

pg_advisory_xact_lock breaks Cockroach Compatibility #277

Open obeleh opened 1 year ago

obeleh commented 1 year ago

Commit: https://github.com/cyrilgdn/terraform-provider-postgresql/commit/fa723cf7e081dd28e8c431ee43d9c4dd41390f57

│ Error: could not get advisory lock for role sjuul: pq: unknown function: pg_advisory_xact_lock(): function undefined
│ 
│   with postgresql_database.test_db,
│   on dbs.tf line 1, in resource "postgresql_database" "test_db":
│    1: resource "postgresql_database" "test_db" {

It appears that cockroach is not going to implement this: https://github.com/cockroachdb/cockroach/issues/13546

Would it be possible to opt out on a provider level?