Torque compatibility issue with Rails 8: removal of executive and clear

[denizcay]

Upgrading Rails application 7.0.4 to 8 has caused a compatibility issue with the Torque gem. The removal of the execute_and_clear method in the PostgreSQL connection adapter in Rails 8 is preventing the gem from loading custom types.
As a result, I'm receiving the following error:

torque/postgresql/adapter/database_statements.rb:119:in `torque_load_additional_types': 
undefined method `execute_and_clear' for #<ActiveRecord::ConnectionAdapters::PostgreSQLAdapter:0x0000000000df48 
env_name="development" role=:writing> (NoMethodError)
    execute_and_clear(query, 'SCHEMA', []) do |records|
    ^^^^^^^^^^^^^^^^
Did you mean?  execute_batch 

Environment:
Rails: 8.0.0
Ruby: 3.2.2
Torque: 3.4.1

Perhaps there's a different approach that could be used to achieve the same functionality as execute_and_clear. I'm open to any suggestions or workarounds that might be helpful.

[alperenbozkurt]

I have same issue with you. I created a pr for this issue. #106

[jamesst20]

Hey @crashtech same issue here with Rails 8, do you have any plans of looking into it?

[crashtech]

I have a couple of Rails 8 things to address. As soon as I have some time I will work on them.