Problemsby GlyphTrouble with PostgreSQL function
3 posts from 3 people3d activeSteady, +1 this week
Posts per day
The posts behind it
pg-meta: editing a function corrupts scalar config_params (SET ... TO) values
...so a value that contains a space, hyphen, `=`, or other non-identifier character either fails to parse or silently loses its surrounding quotes when the function is saved. This is the write-path counterpart to #51916 (the read-side `=` truncation, addressed in #51999). It...
How to bypass PostgreSQL's 100 function parameter limitation for IN and FIELD
I'm hitting the 100 parameter limit wall for a Postgres function. See an example below, though there can be an arbitrary number of ids in the lists:. select id, contained_by, hsmtype from hsm_table where id in ('007cbf96-7e97-469e-b5fe-eabee9378113',...
PL/pgSQL LOOP two times over function result set without re-evaluating it
...a function that returns a table. Now I want to loop over the rows in another function. Is there a way to loop twice over the same result without having to execute the query twice?. I know that I can loop over the table and create a JSONB object and then loop over this object in...
Companies and products named
About this problem
Evidence
3 posts from 3 people in 2 places, about 1 a week over 61 days. Mostly on Stack Overflow [postgresql], supabase/supabase. Tools named alongside: Supabase.
Frustration Frustration 0 of 3· Seen on Stack Overflow, GitHub issues
How it was grouped
Posts about PostgreSQL with no known issue, sharing the word "function". First post Aug 31, 2026, latest Oct 30, 2026. Corroborated: 3 or more posts from 2 or more people or places. Method
Other PostgreSQL problems
PostgreSQL permissions are confusing and error-prone
7 posts from 7 people on GitHub issues, Hacker News.
PostgreSQL users keep filing bugs
Top post: "Postgres row-level security leaks across tenants when using a pooled connection", one of 38 posts from 37 people on GitHub issues, Stack Overflow, Reddit.
PostgreSQL upgrades break working setups
12 posts from 11 people on GitHub issues, Stack Overflow, Reddit.
PostgreSQL queries run too slowly and are hard to tune
8 posts from 8 people on Reddit, Stack Overflow, GitHub issues.
Trouble with PostgreSQL database
Top post: "Canonicalising unit names from a flat file in a normalised database structure", one of 6 posts from 6 people on GitHub issues, Stack Overflow.
PostgreSQL error messages are cryptic
6 posts from 6 people on GitHub issues, Stack Overflow.
PostgreSQL feels slow and laggy
4 posts from 4 people on Mastodon, Reddit, GitHub issues.
PostgreSQL connectors and syncs are fragile
4 posts from 4 people on GitHub issues, Hacker News.
Trouble with PostgreSQL server
Top post: "SQL Server to PostgreSQL sync missing some records", one of 3 posts from 3 people on Reddit, GitHub issues, Stack Overflow.
PostgreSQL jobs fail silently or break often
3 posts from 3 people on GitHub issues.
PostgreSQL hits connection, locking and scaling limits
3 posts from 3 people on Reddit, GitHub issues, Stack Overflow.
Trouble with PostgreSQL shared
Top post: "The same UPDATE intermittently needs far more shared buffers for about a minute", one of 3 posts from 3 people on GitHub issues, Stack Overflow.
History