Error rails 7.2.2 plsql 17.6 restrict - unrestrict, structure.sql

[ElWorking]

When there is an error in the structure.sql dump due to rule restrictions generated by the PL/pgSQL version, Apartment does not have a native solution for it. This workaround is added in the project initializer.

require 'apartment/adapters/postgresql_adapter'

Apartment::Adapters::PostgresqlSchemaFromSqlAdapter::PSQL_DUMP_BLACKLISTED_STATEMENTS =
  (Apartment::Adapters::PostgresqlSchemaFromSqlAdapter::PSQL_DUMP_BLACKLISTED_STATEMENTS + [/\\restrict/i, /\\unrestrict/i]).freeze

[jaydorsey]

For some additional context, it looks like the changelog noted here details a change to postgres (that's for 15, but i'm sure it's also in 16/17)

The patch suggested above unblocks this issue

[github-actions]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.

[moskvin]

I've adjusted code to filter \restrict without syntax error in #329

[mnovelo]

released! https://rubygems.org/gems/ros-apartment/versions/3.3.0