Problemsby GlyphPostgreSQL users keep filing bugs
42 posts from 41 people27d activeSteady, +4 this week
Posts per day
The posts behind it
`UNION ALL of JOINs` vs `JOIN on UNION ALL` performance
Why do. UNION ALL of JOIN s and. . JOIN on UNION ALL . . cost so different amount of Index Only scan s (and time) in PostgreSQL (14)?. EXPLAIN (ANALYZE ON, VERBOSE ON, COSTS OFF) SELECT n.id FROM public.sample s JOIN public.ta n ON s.id = n.id UNION ALL SELECT n.id FROM...
Best way to attach one “primary image” per row to a paginated SKU listing
I’m building a paginated listing over a large catalog: several thousand SKUs today (and growing), each with multiple images. The listing supports search, many filters and sorting, and users can pick a page size between 8 and 500 rows. Each row must show one thumbnail: the image...
Instance owner cannot view execution data in a team project when the execution uses a credential of that project
...the redaction policy is `none`, and when the data redaction feature is not licensed. Workaround: open the credential, go to the Sharing tab, and share the credential with your own user. After this, the execution data is visible. ### To Reproduce 1. Sign in as the instance owner...
[Bug]: max_budget admits calls after spend has crossed it (11 calls on a budget that fits 9)
**What happened** A virtual key with `max_budget` of $0.0045 admitted 11 calls costing $0.0004512 each, for $0.0049632 billed (+10.3%). Running calls one at a time gave the same count as a burst of 30. One call past the budget is expected if the check runs before the cost is...
vault external problem in approle method
### Bug Description Hi i have a problem with n8n. i have installed n8n on k8s using helm method. n8n --version 2.44.7 and node --version v26.12.1 when i want to use vault as external secret i use approle for authentication method but i get Failed to authenticate error. i only...
vault external approle method problem
### Bug Description Hi i have a problem with n8n. i have installed n8n on k8s using helm method. n8n --version 2.44.7 and node --version v26.12.1 when i want to use vault as external secret i use approle for authentication method but i get this error i only fill the vault url...
Java generator showing "warning: ambiguous type name" from two functions with same name, distinct parameters
I'm using jooq 3.20.* Is the error below expected? If so, I presume the only remedy is to rename one of the functions?. create or replace function public.genome_pvalue_mono( pbsg_name text, markers_id uuid, conf float, empirical boolean ) returns table (segment_id uuid, base1...
transaction() silently succeeds when COMMIT rolls back
Hey 👋 Thanks for making the JS world a better place! When catching a unique constraint violation inside `transaction()` without rolling back to a savepoint, the transaction remains aborted. PostgreSQL responds to `COMMIT` with `ROLLBACK`, but `transaction()` resolves....
How can I audit PostgreSQL virtual generated columns when OLD and NEW contain NULL?
I want to use the same audit trigger across different tables without copying their generated column formulas into the trigger.. The problem is that RETURNING gives me the calculated values but the trigger writes null for those same columns. This happens with an AFTER trigger...
How are you managing DB architecture for AI agents that need real-time state and historical data?
...needs to make a decision right now based on past data, waiting on a data warehouse sync doesn't work.. For those building context-heavy AI features, how are you bridging the two?.
[Feature] Periodic testing of Postgres ADBC driver on macOS
### Is this your first time submitting a feature request? - [x] I have read the [expectations for open source contributors](https://docs.getdbt.com/docs/contributing/oss-expectations) - [x] I have searched the existing issues, and I could not find an existing issue for this...
Resetting filters in SettingsSkillsView leaves the previously selected agent pinned in agentFilterOptions
### Bug Description In `packages/frontend/editor-ui/src/features/settings/context/views/SettingsSkillsView.vue`, selecting an agent from the remote-search Agent filter dropdown sets `selectedAgent.value` inside `onAgentChange` (lines 222 to 225) so `agentFilterOptions` (lines 97...
Freshservice credential type not selectable
## Describe the problem/error/question You can create a credential of type Freshservice, but when you insert a "http request" node and select "Predefined credential type", "Freshservice API" is not present in the list ## What is the error message (if any)? ## Please share your...
[Bug]: /global/spend/reset zeroes DB spend but an exhausted key stays refused with budget_exceeded
### Description POST /global/spend/reset with the master key returns 200 and zeroes `LiteLLM_VerificationToken.spend` and `LiteLLM_TeamTable.spend`, but the next chat on a key that had exhausted its max_budget is still refused with 422 budget_exceeded (`Current cost: 0.13, Max...
more PostgreSQL compatibility with simple macros (PR ready)
### What happens? official documentation of duckdb says that its [SQL Dialect](https://duckdb.org/docs/lts/sql/introduction) is very close to pg, I've previously contributed a simple PR to have duckdb act as pg server, good enough to make [vscode SQLTools...
Why is copy_to/copy_from faster than cursor.fetchall?
...only start reading the data once its already written to the file, which is a complete lack of pipelining.. I understand that "copy_to is faster than fetchall" but it doesn't line up with my existing understanding of how query results are produced so something in my existing...
Dashboard: misleading role grouping and Delete action for postgres
# Bug report - [x] I confirm this is a bug with Supabase, not with my own application. - [x] I confirm I have searched the Docs, GitHub Discussions, and Discord. ## Describe the bug The hosted Dashboard's Database → Roles page places `postgres` and `supabase_privileged_role`...
Data Analytics Best Practices
...to rigid standards only to produce a product that is never used by anyone. If you can't find a good way to automate a part of a process, ask a couple coworkers and move forward with your best idea.. 1 Repeatable Processes. All of the data processing, importing, cleaning,...
[Studio] Default privileges state misses grants made TO PUBLIC
# Bug report - [x] I confirm this is a bug with Supabase, not with my own application. - [x] I confirm I have searched the Docs, GitHub Discussions, and Discord. ## Describe the bug Studio's default-privileges state query misses grants made TO PUBLIC. File:...
fix(docs): SSL Configuration Settings
# Improve documentation ## Link https://supabase.com/docs/guides/database/psql#connecting-with-ssl ## Describe the problem The SSL Configuration docs page did not have any links/directions to actually find the SSL configuration settings in the project dashboard. There is one...
[Feature]: Size-based spend-log cleanup with resumable runs and physical storage reclamation
...monitoring, and PostgreSQL logs to understand progress and why cleanup stopped. 5. My workaround is operational tuning and investigation of vacuum behavior and partitioning; after a database restart, I also have to determine whether cleanup will continue. **After this feature...
fix(realtime-prompt): INSERT authorization example uses unsupported USING clause
## Summary The Authorization Setup section in `examples/prompts/use-realtime.md` tells readers how to authorize writes to a private channel, but its `FOR INSERT` policy uses `USING (...)`. PostgreSQL INSERT policies accept `WITH CHECK` expressions, not `USING` expressions, so...
Support Message
Subject: PostgREST returns “public.public.*” for tables that exist in public Project ref: ylspdrjrvhixrregmqtg Issue: All calls to bible_books and translations via the Data API fail with: { "errors": { "books": { "message": "Could not find the table 'public.public.bible_books'...
Need help in getting hands on
I am a full-stack developer (back-end and ops heavy), who has recently started learning about the internals of PostgreSQL.. I am currently referring a very beautiful book called PostgreSQL 14 Internals by Igor Rogov .. I am very excited to learn the theory which earlier used to...
Tokens burned with NO results.
Type: Bug Why does the system take tokens, even though it failed to return results. VS Code version: Code 1.137.0 (645f29cc3176500b4b5762ba887cf2a7f0ffdf2c, 2026-09-08T13:43:59-07:00) OS version: Windows_NT x64 10.0.26200 Modes: Remote OS version: Linux x64 6.8.0-100-generic...
Is my Postgres schema migration safe or not safe?
...team (b/w 2019-2023), where my team had to support ~170 product teams. The biggest bottleneck was schema migration.. We had to manually review, publish best practices, put CI guardrails, etc. The challenge is that most of the developers just want a simple answer. Is it safe or...
How should I handle retries when a Spring Boot service provisions a PostgreSQL cluster through a cloud API?
I'm working on a Spring Boot service that provisions PostgreSQL clusters through a cloud provider's API.. The provider's API is asynchronous, so my endpoint roughly works like this:. POST /clusters | v Spring Boot | v Cloud API | v operation ID I return 202 Accepted to the...
[BUG]:make NL2SQLTool dialect-aware for SQLite and PostgreSQL
...WHERE name ILIKE '%john%' or DATE_TRUNC('month', created_at)), which throws a syntax error when executed on SQLite. ### Expected behavior When connected to or configured for PostgreSQL, NL2SQLTool should output PostgreSQL-compliant SQL (e.g., using ILIKE, INTERVAL, ::text...
Prisma 7 + @prisma/adapter-pg fails with "self-signed certificate in certificate chain" on Aiven Postgres
I'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...
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...
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) -...
My adaptive system captures Week 1 feedback, but Week 2 won’t automatically update from it. How would you debug this loop?
...is how to design the system so that a broken Week 1 → Week 2 adaptation chain becomes impossible to miss .. Conceptually I think I want something like:. observation. → feature snapshot. → decision context. → exposure. → measured outcome. → response attribution. → athlete-state...
Postgres row-level security leaks across tenants when using a pooled connection
I 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 =...
Managed Postgres: --pitr-time refused while --backup-id restore works, how do I read the recovery window?
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...
How do I know with 100% if GEQO was used or not?
I found this SO[0] question that says there is no direct and reliable way to know. The proposed ways are: . - counting the join count.. - comparing plan across runs. If it differs, it was used, otherwise we can't really tell. - analyzing debug logs (which might be reliable or...
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...
Book recommendations for PostgreSQL deep dive
...for book recommendations but most of what I can see are self-promotes, which are difficult to gauge for quality/purpose; or "how to use PostgreSQL" books. I could probably learn a decent amount from the latter by skimming past the parts I know (though I unfortunately get...
Project DNS not resolving - NXDOMAIN
The 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...
GoTrue auth endpoints frozen — project hwlpnmdbtiwatbehdcpc
Project 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...
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...
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...
Companies and products named
About this problem
Evidence
42 posts from 41 people in 15 places, about 4 a week over 71 days. Mostly on Stack Overflow [postgresql], supabase/supabase, n8n-io/n8n. Tools named alongside: GitHub, Supabase, n8n, Docker.
Frustration Frustration 0 of 3· Seen on GitHub issues, Stack Overflow, Reddit, Community forums
Summary, model-written
PostgreSQL users face issues with row-level isolation policies, audit trigger generated columns, and query cost differences in UNION ALL operations.
How it was grouped
Posts about PostgreSQL that state a pain but match no known issue yet. First post Aug 27, 2026, latest Nov 5, 2026. Corroborated: 3 or more posts from 2 or more people or places. Method
Other PostgreSQL problems
PostgreSQL vulnerabilities are hard to triage and patch
2 posts from 2 people on Glyph Ibis. Unverified.
PostgreSQL upgrades break working setups
13 posts from 12 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.
PostgreSQL error messages are cryptic
7 posts from 7 people on GitHub issues, Stack Overflow.
PostgreSQL permissions are confusing and error-prone
7 posts from 7 people on GitHub issues, Hacker News.
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 jobs fail silently or break often
5 posts from 4 people on GitHub issues.
PostgreSQL feels slow and laggy
5 posts from 5 people on Mastodon, Reddit, GitHub issues.
Trouble with PostgreSQL workflow
Top post: "Agent not recognizing the workflow inputs", one of 4 posts from 4 people on GitHub issues, Stack Overflow.
PostgreSQL outages and slowdowns disrupt work
4 posts from 4 people on GitHub issues, Reddit.
Trouble with PostgreSQL credentials
Top post: "SFTP Credentials: Port field clears value and incorrectly formats large port numbers", one of 4 posts from 4 people on GitHub issues.
PostgreSQL connectors and syncs are fragile
4 posts from 4 people on GitHub issues, Hacker News.
History