new RLS feature from Neon
any RLS aficionados in here? we have a pretty cool new feature around making RLS easier and would love to get a few users testing
create role error
Hi Tristan,
It's a service account that automatically creates the role upon request. I'm not sure to how exactly this service account creates roles.
Obviously the best course here is to create the role with password, but in my case with the service account that's not possible....
My Neon console is showing the database
My Neon console is showing the database is running but the prisma is unable to connect it. I checked the connection string but it not able to connect.
Hello, I don't know which branch to ask
Hello, I don't know which branch to ask this question, so I will ask it here. As I understand it, Neon doesn't work with postgres as 2 different applications, so the question is how do you avoid longjmp from postgres in case of a critical error. Can someone tell us or give a link to this discussion?
In regards to databases with serverless
In regards to databases with serverless deployment, does Neon offer features like built-in triggers, push/pull updates (firebase/supabase) or other database features along those lines? Would we have to develop in house solutions ourselves?
support/connections
Okay, so I'm likely going into the basic plan, how can I get a good idea of my limitations, and am I supposed to contact support to get past the 64 default connections? Sorry, if these are dumb questions.
How are we able to rollback transactions
How are we able to rollback transactions made within the Neon rest api?
trying to connect with psql from win 10
trying to connect with psql from win 10 box, but getting a connection error. all I do is, run "psql postgresql://neondb_owner:GBPr1epQY8Cg@ep-white-dew-a6toqdmj.us-west-2.aws.neon.tech/neondb?sslmode=require" from a cmd line prompt. what am I missing?
You're welcome. Do consider hosting
You're welcome. Do consider hosting Redis or some in-memory solution on Neon if possible. Would love it.
hey I'm new here , I found neon is a b
hey I'm new here , I found neon is a b etter alternate to meta , how to see my server or dashboard of postgreSQL
Hi, I use postgres. I connected and have
Hi, I use postgres. I connected and have error: ERROR: remaining connection slots are reserved for roles with the SUPERUSER attribute. Please help me
Does neon work as a solution for
Does neon work as a solution for postgres with schema based multi-tenancy?
hello, i keep getting this error when
hello, i keep getting this error when trying to connect .. it connected at. home but right now I am at the library and it is no longer connectiing .. does anyone have any advice ? Error connecting to PostgreSQL Database: connection to server at xyz.us-east-2.aws.neon.tech port 5432 failed: Operation timed out
Is the server running on that host and accepting TCP/IP connections?...
conn = _connect(dsn, connection_factory=
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError: connection to server at "ep-billowing-resonance-a54yftck.us-east-2.aws.neon.tech" (3.143.47.40), port 5432 failed: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
I got this error when I try to "py manage.py migrate"...
hiya, is there a way to change the owner
hiya, is there a way to change the owner of a database to a different role? trying to run any postgres sql command gives me a permission denied error
Hi, I am wondering why the following sql
Hi, I am wondering why the following sql alter table statement is taking over 10 minutes and locking up our db (adding this to a table with 2.7M rows)
...
ALTER TABLE public.results ADD COLUMN updated_at TIMESTAMP;
ALTER TABLE public.results ADD COLUMN updated_at TIMESTAMP;
Is the `DatabaseError` class from `@
Is the
DatabaseError class from @neondatabase/serverless the same as PostgresError from the postgres package? Reason I'm asking is because I'm implementing errorhandling, and I want to type narrow the error type that is thrown when violating something like unique constraints forexampleHmm how does Neon perform with
Hmm how does Neon perform with transactions? Just added a Pooled connections with my Drizzle ORM. Basically the transaction performs 500 inserts in to 1 table, and the result of the main ID is used to create related records that is usually
1 -> 1.2 in relation ratio. but each batch with related data transactions takes about 40-50 seconds to insert. (using Drizzle ORM) R and W comes from the same Neon DB instance