Skip to content

Fix incorrect ParameterStatus key casing for DateStyle, TimeZone, and IntervalStyle #5145

@rahim-kanji

Description

@rahim-kanji

Summary

PostgreSQL clients treat ParameterStatus message names as case-sensitive and expect canonical capitalization for certain parameters.
Three parameters in PostgreSQL use capitalized names instead of lowercase for historical reasons:

  • DateStyle
  • TimeZone
  • IntervalStyle

These parameters predate the unified GUC (Grand Unified Configuration) system and retained their mixed-case names for backward compatibility.
Because ProxySQL previously sent them as datestyle, timezone, and intervalstyle, some PostgreSQL clients failed to recognize them and ignored their values.

Fix

  • Updated ProxySQL to send canonical capitalization for DateStyle, TimeZone, and IntervalStyle.
  • All other ParameterStatus keys continue to use lowercase names, consistent with PostgreSQL.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions