#3236·spicedb

postgres-fdw docs: `has_permission = true` examples do not work

Author: capybara-altCreated Jul 15, 2026Updated Jul 15, 2026

The Lookup Resources / Lookup Subjects examples in internal/fdw/README.md (and a few in Architecture.md) filter on AND has_permission = true, but running them as documented fails:

ERROR:  unsupported feature or query type: unsupported select statement: operation not supported: column_ref:{...sval:"has_permission"...}
ERROR:  unsupported feature or query type: unsupported select statement: operation not supported: column_ref:{...sval:"has_permission"...}

Postgres folds = true into a bare column reference before pushdown, and the proxy rejects has_permission in WHERE clauses.

Writing the filter as has_permission IS true works through postgres_fdw (it's evaluated locally as a Filter instead of being pushed down), so the README examples should use that. The Architecture.md examples describe SQL as received by the proxy, where no local filtering exists — those should just drop the condition.