Comments (4)
Maybe the correct behavior in this case is to warn instead of crashing
I'm not sure how to go about warning the user that the DELETEs failed. Can you clarify?
Ah, my ideas where not clear when I mentioned that(they were not directly related to DELETEs).
But I was thinking that we could have a guc like pg_net.is_worker_on=true
and when this is false(worker down) calling all the functions(like net.http_get
or net.http_post
) would fail. That would prevent having a lot of http requests on the queue.
from pg_net.
Another simple way is to just remove the PKs of the tables. This should also help with stability in the meantime as inserts will be faster.
from pg_net.
One small win: rename http_request_queue
to _http_request_queue
.
This is a private API, so when a user interacts with it, all bets are off. As far as I'm concerned, this is working as intended.
So the improvement to be gained here is on UX of user errors.
Maybe the correct behavior in this case is to warn instead of crashing
I'm not sure how to go about warning the user that the DELETE
s failed. Can you clarify?
from pg_net.
One small win: rename http_request_queue to _http_request_queue.
I agree. Also, right now the worker crashes/restarts forever when there's a TTL failure - it should only die once and pg_net functions should refuse to work when the worker is down.
from pg_net.
Related Issues (20)
- i can not compile pg_net on centos HOT 3
- Multiple versions of nixpkgs HOT 1
- Add retries HOT 6
- ERROR: extension "pg_net" has no installation script nor update path for version "0.7.3" HOT 2
- "SSL connect error", "Error in the HTTP2 framing layer" while using edge functions HOT 3
- Show libcurl version
- Fail to compile with the latest libcurl 7.76.1
- Error with net.http_post : query has no destination for result data HOT 1
- UNLOGGED table segfault causing whole cluster to restart HOT 1
- Order is not guaranteed on rapidly generated requests to same end point.
- pg_net prevents `DROP database foo` from succeeding
- Can't send HTTP requests to localhost from a trigger function HOT 16
- `net._http_response` rows do not respect TTL
- Failed to toggle PG_NET: failed to create pg.extensions: function net.http_collect_response HOT 8
- Cannot enable pg_net extension HOT 1
- pg_net not working in self-hosted supabase HOT 7
- pg_net doesn't support 308 redirects HOT 1
- Test Failures due to Timeout HOT 5
- cleanup of net._http_response table HOT 11
- Self Hosted / Docker `supabase/postgres:15.1.0.109_arm64` : Worker does not execute requests HOT 7
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pg_net.