I want to scan a little RFID tag with my phone and a row is created in Postgres.



I noticed a weird error:

prepared statement \"s7\" already exists

On every other request to the API…


This GitHub issue was exactly it. I needed to use the non-pooler Neon connection URL. Once I changed to the different URL I was good to go.


The dedicated script type for just Postgres is great, no creating and closing a connection, just give it an input and a connection and your good to go.

If you try to call it via a webhook you have to provide db connection info… that seems odd. So if you do want to have a webhook in front of it you need to use a flow. So you’ll call the webhook for the flow and the defaults in your flow will call this Postgres script as expected.