Skip to content
Problems.

PostgreSQL users keep asking for help

Databases26 posts from 25 people15d active+77 posts in the last 7 days, 7 the 7 days before (steady)

Posts per day

Posts per day26 posts, Aug 27 to Sep 25

The posts behind it

26, newest first
PostDate
Deployment job_variables cannot be cleared: an empty dict is ignored on upsert and update### Bug summary We can't reset a deployment's `job_variables` to `{}` once it has some. Both `POST /deployments/` (upsert) and `PATCH /deployments/{id}` ignore `job_variables: {}`, so the deployment keeps the old overrides. Then, flow runs never use the work pool base job...PrefectHQ/prefectshotarokSep 24yesterday
Shared pooler certificate chain fails strict TLS verification: intermediate CA missing Key Usage# Bug report - [ x] I confirm this is a bug with Supabase, not with my own application. - [ x] I confirm I have searched the [Docs](https://docs.supabase.com), GitHub [Discussions](https://github.com/supabase/supabase/discussions), and [Discord](https://discord.supabase.com). ##...supabase/supabasebintilliaSep 24yesterday
How to bypass PostgreSQL's 100 function parameter limitation for IN and FIELDI'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',...Stack Overflow [postgresql]Oliver CoxSep 223 days ago
How can I use a composite IN query with Postgres.js?I'm using Postgres.js and I want to execute a PostgreSQL query using a composite IN condition like this:. SELECT * FROM table WHERE (col1, col2) IN ((1, 2), (2, 3)); In other words, I want to check multiple (col1, col2) pairs at once.. With postgres.js , I tried the following:....Stack Overflow [postgresql]erkanunluturkSep 214 days ago
Prisma 7 + @prisma/adapter-pg fails with "self-signed certificate in certificate chain" on Aiven PostgresI'm connecting a Next.js app to Aiven PostgreSQL using Prisma ORM 7.7.0 with the @prisma/adapter-pg driver adapter. TLS handshake fails with:. Error [PrismaClientKnownRequestError]: Invalid `prisma.user.findUnique()` invocation: Error opening a TLS connection: self-signed...Stack Overflow [postgresql]RoodiusSep 214 days ago
How should I design an auditable KYC review workflow with multiple verification stages using DIDit?I am building a fintech application with a multi-step customer onboarding and KYC process. The backend is built with NestJS and PostgreSQL, and I am using an external KYC provider (Didit) for identity and document verification.. A typical personal onboarding flow looks like:....Stack Overflow [postgresql]Parshant KhichiSep 214 days ago
How to configure pg to work natively with Temporal.PlainDate?...I would like pg to return either a string like the database or a Temporal.PlainDate .. Is there a way to override the pg parser to achieve this? If so, please link to a documentation page or suggest which file to include the override in for an Express.js project, and the...Stack Overflow [postgresql]hb20007Sep 205 days ago
Error viewing / downloading binary file### Bug Description ### To Reproduce 1. Webhook accepts binary files 2. View files / download files in execution history ### Expected behavior Can view and download normally ### Debug Info # Debug info ## core - n8nVersion: 2.39.8 - platform: docker (self-hosted) -...n8n-io/n8nsei-lukaSep 187 days ago
Self-Hosted: JWT config applied to wrong database when using custom POSTGRES_DB### Bug description I was setting up a self-hosted instance and wanted to use a custom database name instead of the default `postgres`. After changing `POSTGRES_DB` in my `.env` file, I noticed that auth and RLS weren't working correctly. I dug into the Docker initialization...supabase/supabasemandar1045Sep 169 days ago
Postgres row-level security leaks across tenants when using a pooled connectionI have a multi-tenant app on Postgres with row-level security. Each request sets the current tenant before querying, using a connection checked out from a pg Pool.. Policy on the table:. CREATE POLICY tenant_isolation ON risks USING (tenant_id =...Stack Overflow [postgresql]Muhammad SufyanSep 1510 days ago
Managed Postgres: --pitr-time refused while --backup-id restore works, how do I read the recovery window?Fly.io CommunitykamzaSep 1510 days ago
PostgreSQL /flow_runs/filter times out for state-filtered START_TIME_ASC queries on large flow_run tables### Bug summary We observed `POST /flow_runs/filter` returning HTTP 500 for the following query against a self-hosted Prefect server using PostgreSQL: Our `flow_run` table contained approximately 6.35 million rows (26 GB), including approximately 27,000 `RUNNING` rows. Prefect...PrefectHQ/prefectSuperLamicSep 1510 days ago
Fetching Delta Deployment Stage DependencyOrdering...It existed at the target, however, this dependency was done prior to apply.. Is there a workaround for this or a setting that I could use to make this work and keep the object grouped repository structure? The solution that allowed the pipeline to pass was to place all functions...Stack Overflow [postgresql]Ross BushSep 1411 days ago
Workflows & credentials import fails when user specified by `--userId` is the existing owner...like `n8n import:workflow` and `n8n import:credentials` throw an ownership conflict error when re-importing entities for a user specified via `--userId`. Issue fixed by #36278 ### To Reproduce 1. Import a workflow in n8n using `--userId` 2. Validate the workflow has been...n8n-io/n8nGauthierPLMSep 1411 days ago
Extended ASCII database password issue...is accepted when configuring the project, but the Supabase dashboard is subsequently unable to connect to the PostgreSQL database and reports that the Postgres user could not authenticate. ## Steps to reproduce - Create a Supabase project or change the database password. - Set a...supabase/supabasetyk3wSep 82 weeks ago
Should semi-structured product attributes (secondary images, specs) be stored as JSONB or normalized tables?I am designing a relational database schema for an e-commerce platform where the backend receives product objects structured like this:. { "id": 101, "categoryId": 1, "name": "Galaxy S22 Ultra 5G", "price": 67999, "stockQuantity": 18, "imageUrl": "https://...", "imagePublicId":...Stack Overflow [postgresql]bibashmanjusubediSep 43 weeks ago
How can multiple offline clients decrement a bounded counter without oversubscribing after synchronization?I am building an event check-in system using Laravel 13, PostgreSQL 16 and React. An invitation can admit multiple people and can be used partially:. invitation ----------- id seats // maximum allowed seats_used // admitted so far Several ushers may check guests in...Stack Overflow [postgresql]Japhary H. MwangaSep 23 weeks ago
How do I modify the SwiftData custom DataStore and snapshots to handle different model objectsIn the sample code shown here, I am reading and writing ProductRecord model objects to/from PostgreSQL using a custom DataStore .. However, it is unclear to me how I can set this up such that I am able to also write other model object types to the same custom DataStore .....Stack Overflow [postgresql]Duncan GroenewaldSep 23 weeks ago
extracting data from on-prem databases (sql server, oracle, postgres) to cloud, which options you guys recommend?...one of the things we're thinking is to retire the ADF. the reason is simple: ADF is a pain in the ass (we're having a hard time working with it specially because it was another company that build all that shit, the connection with Azure DevOps/Repos is always horrible to manage...r/dataengineeringu/Comprehensive_Level7Sep 13 weeks ago
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...Stack Overflow [postgresql]FloratAug 313 weeks ago
Query builder generates invalid SQL for empty in filters# Query builder generates invalid SQL for empty `in` filters ## Bug Passing an empty array to an `in` filter generates PostgreSQL syntax such as: PostgreSQL rejects `IN ()` with a syntax error. Tuple filters have the same problem: ## Reproduction This is reachable in Studio's...supabase/supabaseZuhefAug 313 weeks ago
Project DNS not resolving - NXDOMAINThe project domain https://bvbemymfnhkzjlhgdya.supabase.co returns NXDOMAIN on all DNS resolvers (Google 8.8.8.8, Cloudflare, cron-job.org, pg_net). This prevents: - Edge Functions from being called externally - pg_net HTTP requests from PostgreSQL - External cron services from...supabase/supabasehenrypeterofc1Aug 284 weeks ago
GoTrue auth endpoints frozen — project hwlpnmdbtiwatbehdcpcProject ref: hwlpnmdbtiwatbehdcpc Project name: Abi Elderly Care Region: ap-northeast-1 Issue: Supabase Auth (GoTrue) is completely unresponsive. Login and signup fail on all portals. What we already tried: - Turned OFF custom SMTP (using default mailer) - Turned OFF Confirm...supabase/supabasevenkat0718Aug 284 weeks ago
The same UPDATE intermittently needs far more shared buffers for about a minutePostgreSQL 17.10 on Azure Database for PostgreSQL Flexible Server. A large, high-write OLTP table with more than a dozen indexes, all plain btree, no GIN or other index types. Rows are inserted once, then updated repeatedly as they move through a state machine.. The dominant...Stack Overflow [postgresql]DamianAug 274 weeks ago
Timestamp ordering and cursor pagination with 13-digit Unix timestamps...when using postgres.js.. What is the recommended way to implement this?. Specifically:. How should I convert a 13-digit Unix timestamp in milliseconds to a PostgreSQL timestamp for comparison?. What is the correct way to implement after / before cursor pagination with...Stack Overflow [postgresql]erkanunluturkAug 274 weeks ago
Reduce CPU spent compiling PostgreSQL event persister inserts### Bug summary The PostgreSQL event persister embeds every event and resource row into its SQLAlchemy `INSERT` statements with `.values(rows)`. The resulting expression trees grow with the batch, so statement compilation consumes substantial persister CPU before PostgreSQL is...PrefectHQ/prefectchuqCTCAug 274 weeks ago

Companies and products named

Company or productPosts naming it
PostgreSQL26
Supabase6
GitHub3
Prefect3
Docker2
n8n2
About this problem

Evidence

26 posts from 25 people in 6 places, about 5 a week over 29 days. Mostly on Stack Overflow [postgresql], supabase/supabase, PrefectHQ/prefect. Tools named alongside: Supabase, GitHub, Prefect, Docker.

Frustration Frustration 1 of 3· Seen on Stack Overflow, GitHub issues, Community forums, Reddit

How it was grouped

Posts about PostgreSQL that state a pain but match no known issue yet. First post Aug 27, 2026, latest Sep 24, 2026. Corroborated: 3 or more posts from 2 or more people or places. Method

History

  • 2026-09-25 Momentum: rising to steady
  • 2026-09-25 Added: PostgreSQL users keep asking for help (15 posts)

Rising problems by email

Mondays: the problems in data, tech and AI that grew fastest that week.

Double opt-in. Unsubscribe any time.