Rails Daily: PostgreSQL 18 Support and Security Updates

Rails merged 10 pull requests with major PostgreSQL 18.4+ improvements including NOT ENFORCED foreign keys and referential integrity changes. A security fix limits string-to-integer conversion to prevent DoS attacks.

Duration: PT1M47S

Episode overview

This episode is a short developer briefing from Rails Daily.

It explains recent repository work in plain language.

  • Show: Rails Daily
  • Published: 2026-05-20T10:01:50Z
  • Audio duration: PT1M47S

Transcript excerpt

This excerpt keeps the crawler page concise. Listen to the episode or use the RSS feed for the full update.

Good morning, this is Rails Daily for Tuesday, May 20th, 2026.

Yahonda merged two significant PostgreSQL 18.4+ improvements. The first adds an enforced option for foreign keys, allowing table owners to toggle enforcement without superuser privileges. The second updates disable_referential_integrity to use NOT ENFORCED instead of DISABLE TRIGGER ALL, also removing the superuser…

Aaron Patterson merged a security fix limiting the size of strings passed to to_i in ActiveRecord. The change prevents potential DoS attacks by restricting auto-integer coercion to 16 bytes for default integers and 32 bytes for bigints.

Fatkodima contributed two database enhancements: adding exclusion_constraint_exists and unique_constraint_exists helpers for PostgreSQL, and merging Shouichi's pull request to accept Tempfile as an ActiveStorage attachable.

Kyle Keesling fixed a query cache invalidation bug where UPDATE statements going through update_with_result weren't properly clearing the cache, affecting PostgreSQL tables with generated stored columns.

Thomas Sevestre added proc and symbol support for NumericalityValidator's in option, enabling dynamic range validation based on object state or methods.

Nearby episodes from Rails Daily

  1. Weekly Recap - Error Handling & Developer Experience
  2. Error Messages and Developer Experience
  3. Concurrency and Threading Fixes
  4. Parameter Safety and Date Format Improvements
  5. Cache Controls and Documentation Updates
  6. Query Fixes and Documentation Overhaul
  7. ActiveRecord Job Enhancement
  8. Weekly Recap - Database Performance & Optimistic Locking