## TL;DR

Upgrade to 1.58.2 or later; a nightly build containing the fix was also available while the release was being cut. This was a Flipt bug in the Postgres write path for segment operators, fixed in release 1.58.2.

## Steps

1. This was a Flipt bug in the Postgres write path for segment operators, fixed in release 1.58.2. The reporter confirmed 1.58.2 resolved it. Upgrade to 1.58.2 or later; a nightly build containing the fix was also available while the release was being cut.

## When to use

You are seeing this: Running Flipt with Helm and an on-premise Postgres database, everything works until you try to modify any entity: editing a variant flag or a segment constraint fails with ERROR: invalid input syntax for type integer: "OR_SEGMENT_OPERATOR" (SQLSTATE 22P02). Use this skill when you run into "Flipt ERROR invalid input syntax for type integer OR_SEGMENT_OPERATOR SQLSTATE 22P02".

## When not to use

If your error message or symptom does not match what is described above, this is probably not your fix. Search for your exact error text instead of forcing this one to fit.

## Versions

Versions mentioned in the source: 1.58.2. If you are on something much newer or older, the details may have shifted.

## Why this happens

The original report does not dig into a root cause. It documents the symptom and the fix that resolved it.