Neon

N

Neon

The official Neon Database Discord

Join

🙏|feedback

❓|questions-and-answers

🐘|postgres

grumpy-cyan
grumpy-cyan3/21/2025

"Please add a primary key column to your table to update or delete rows"

I'm getting the post title as an error message in the Neon web view when trying to edit or delete rows from the "Tables" view. I've never had an issue with this before today. The DB is created from an Elixir Phoenix project. I haven't not changed my DB. Has something in the Neon web view changed that is now causing this error?
sunny-green
sunny-green3/21/2025

Contradictory database

When I try to update one of the rows on my table, it fails because I "should add a primary key". But when I try to alter the table to make one of my fields a primary key, it says "Multiple primary keys are not allowed".
exotic-emerald
exotic-emerald3/21/2025

I can't update my tables anymore?

Today, i couldn't update my tables that i used to update very often. I get the error message : please add primary key column to your tables to update or delete new rows?!
absent-sapphire
absent-sapphire3/21/2025

Neon on Azure

Is it possible to use azure credits if we provision neon projects via the native integration on azure marketplace?
flat-fuchsia
flat-fuchsia3/21/2025

stack auth with vanilla react , how to setup?

Hi, I noticed stack auth has add support for vanilla react, https://docs.stack-auth.com/react/getting-started/setup ,but Neon's auth dashboard only support next.js integration . Will vallina react with stack-auth work with neon? Thanks...
probable-pink
probable-pink3/20/2025

Azure Marketplace Provisioning

I've attempted several variations of deploying from Azure Marketplace. Each attempt in various regions fails to provision the org within neon. SSO and personal account are created; however, I'm presented with the "Org [generated org id] was not found" Order parameters use a hyphen in the desired orgName field, to match our internal corporate naming convention....
fair-rose
fair-rose3/20/2025

Neon tables in Chrome sometimes reload automatically when I switch tabs in Google Chrome

In Neon Database, every time I switch tabs in Google Chrome, the table reloads the page, causing it to lose its previous state. This issue has been occurring since March 20, 2025.Please advise on how to prevent this from happening?
fascinating-indigo
fascinating-indigo3/19/2025

Permission denied to set parameter "sesion_replication_role"

I have a seed script that runs SET session_replication_role = 'replica' to temporarily remove all FK constraints, so I can seed the db without errors. How can I get the permission back? I'm running as neondb_owner. Alternatively, what do you suggest I do instead if I can't have the permission?
correct-apricot
correct-apricot3/18/2025

update prefix for env vars in vercel

I put the wrong prefix in for the env vars when I first set up the database, and now I can't find a way to update them. Where can I update the prefix?
No description
like-gold
like-gold3/18/2025

ST_Distance_Sphere not available even with postgis enabled

postgis version
POSTGIS="3.5.0 d2c3ca4" [EXTENSION] PGSQL="170" GEOS="3.11.1-CAPI-1.17.1" PROJ="9.1.1 NETWORK_ENABLED=OFF URL_ENDPOINT=https://cdn.proj.org USER_WRITABLE_DIRECTORY=/var/db/postgres/.local/share/proj DATABASE_PATH=/usr/share/proj/proj.db" (compiled against PROJ 9.11.1) LIBXML="2.9.14" LIBJSON="0.16" LIBPROTOBUF="1.4.1" WAGYU="0.5.0 (Internal)"
POSTGIS="3.5.0 d2c3ca4" [EXTENSION] PGSQL="170" GEOS="3.11.1-CAPI-1.17.1" PROJ="9.1.1 NETWORK_ENABLED=OFF URL_ENDPOINT=https://cdn.proj.org USER_WRITABLE_DIRECTORY=/var/db/postgres/.local/share/proj DATABASE_PATH=/usr/share/proj/proj.db" (compiled against PROJ 9.11.1) LIBXML="2.9.14" LIBJSON="0.16" LIBPROTOBUF="1.4.1" WAGYU="0.5.0 (Internal)"
...
fair-rose
fair-rose3/18/2025

Error when creating subscription for replication

Hello, I'm trying to follow a guide for setting up replication between a Postgres database from Supabase into my Neon project database, but I'm getting an error when running the command in Neon to create the subscription. I tried 2 variations and get different errors for each. I'm hoping someone can help me get this working Guide I'm following:...
adverse-sapphire
adverse-sapphire3/16/2025

Can't reach server error

I am making a practo like app and connected neon db from vercel, it was working fine till yesterday, but today as i started the application i am seeing this error I have checked the connection string, also tried adding pooling=true but it's not working...
No description
other-emerald
other-emerald3/15/2025

Is there a way to get a diff of two databases

I have a branch of a database which I've made some changes to. Is there a way to quickly determine the diff between the databases?
ambitious-aqua
ambitious-aqua3/15/2025

I have got some error in DB

Please review it fast and solve it fast
alive-azure
alive-azure3/14/2025

Security measures on Vercel Serverless functions

Hi, Could anyone share guidance on securing Neon when using it with Vercel serverless functions? I’m a bit concerned about having our database accessible over the public internet. ...
exotic-emerald
exotic-emerald3/14/2025

Trying to grant access to public schema, failing to grant access to public schema

I want to use Neon for my Better Auth authentication, to do this I need my user to be able to write to the public schema I've created a new user called inklud_website, and a DB called inklud_website To grant permissions for my user I've ran ```sql...
optimistic-gold
optimistic-gold3/13/2025

Using neon with honoX

Hey! I am trying to use neon with an app i built on honoX (https://github.com/honojs/honox) but i run into a bit of issues. When i follow this guide https://neon.tech/docs/guides/cloudflare-workers i get this:
All attempts to open a WebSocket to connect to the database failed. Please refer to https://github.com/neondatabase/serverless/blob/main/CONFIG.md#websocketconstructor-typeof-websocket--undefined. Details: fetch failed
All attempts to open a WebSocket to connect to the database failed. Please refer to https://github.com/neondatabase/serverless/blob/main/CONFIG.md#websocketconstructor-typeof-websocket--undefined. Details: fetch failed
...
correct-apricot
correct-apricot3/12/2025

if one safekeeper crashes without a way to recover, humans are still needed?

https://neon.tech/blog/paxos, said
If the safekeeper is up again, it can join the cluster automatically. But if it crashes without a way to recover, we need to change cluster membership. Right now, such a change requires humans to be in the loop to ensure that the old safekeeper is actually down. It is on our roadmap to automate this procedure.
was it done? Thanks....