159 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
Score of 2
1 answer
119 views
Ignoring accents in a PostgREST API query with the PostgreSQL unaccent extension
I am using a PostgREST API that queries a PostgreSQL database. In my table, I have a name field containing values with accents such as Léonard. I want to be able to perform a query via the PostgREST ...
- reputation score 144
Score of 2
1 answer
144 views
Why is Operator.Like not found in Supabase-C#?
I'm working with supabase-csharp in a .NET project and trying to perform a database query using a LIKE filter. My code looks like this:
using Supabase;
using System.Collections.Generic;
using System....
Score of 1
0 answers
99 views
How do I diagnose 401 errors using JWT authentication on a postgrest api?
I'm new to postgres and I'm struggling with 401 errors on a project that uses a 'codeless' postgrest api with JWT authentication. Now stuck!
Can anyone suggest what I can do to diagnose what's going ...
- reputation score 11
Score of 0
1 answer
59 views
PostgREST API - mutiple OR conditions. Is it possible?
I'm trying to create a query using PostgREST API with multiple OR conditions.
Essentially I need PostgREST query similar to this SQL query
SELECT * FROM people
WHERE condition1 AND (condition2 OR ...
- reputation score 1
Score of 0
1 answer
246 views
How to join and count using Supabase for Flutter
I have the following:
final data = await supabase
.from('todo_list')
.select('*, items:todo_list_item(*)');
This joins the todo_list_item rows matching todo_list_item.todo_list_fk = todo_list.id ...
- reputation score 11574
Score of 1
1 answer
472 views
Problems using ‘eq’ in a postgrest request
I'm trying to retrieve, in a query, the information for the logged-in user from the users table in my database on supabase. Here's what I do:
val response = supabaseClient.postgrest[‘users’]
...
Score of 0
1 answer
209 views
Tooljet on Docker - Public Schema Error after upgrade
I am struggling a bit with my tooljet installation, here is the setup :
Debian 12 on dedicated hardware
installed with docker (docker-compose) as in the documentation
Everything was working fine, ...
- reputation score 13
Score of 1
2 answers
361 views
Function overloading vs No Function Matches problem
I am needing to update several rows at a time through the Rest API for Postgres. The only way I have figured out how to do this is through a function call, where I pass the JSON to the function and ...
- reputation score 1725
Score of 0
1 answer
339 views
How to do Join on composite key with postgREST?
I am struggling to find the right syntax to perform a (nested) join on on composite foreign keys.
For example, my tables are
CREATE TABLE post (id TEXT PRIMARY KEY, userId TEXT REFERENCES user(id), ...
- reputation score 5
Score of 1
1 answer
406 views
JavaScript Error Code Property "Undefined" - Supabase Auth
The problem is that I am getting "undefined" when I use error.code in JavaScript when I want error.code to spit out meaningful Supabase Auth error codes.
I tried error.message, error.name, ...
- reputation score 31
Score of 1
1 answer
141 views
Join a table with a table-valued function in PostgREST?
I'm hoping to be able to join a table to a table-valued function in PostgREST.
I have an employees table with these fields: id, name, skills--skills is an array of the skill enumerated type.
I created ...
Score of 1
0 answers
179 views
Postgres(t) compression of huge json data for clients fetch call
I am using a Postgres DB to store large JSON data (~2 MB). To view and analyze the data (logfiles from different applications), I have implemented a web server with an Ag-Grid table. Based on ...
- reputation score 11
Score of 0
1 answer
1048 views
How to use PostgrestFilterBuilder from PostgREST without encountering a type error of missing properties that are expected in PostgrestQueryBuilder
First I'm working on a typescript react based project that uses supabase for the backend.
firstly here is my code:
First code image
Second code image
I'm making a resuable component that create or ...
- reputation score 29
Score of 0
0 answers
128 views
PSQL 42501 insufficient privileges after GRANT command
I am currently trying to replicate a system from development to production. Both servers are running Postgresql 14, and Postgrest. I am attempting to update a row in the production system using my web ...
- reputation score 71
Score of 1
0 answers
3837 views
Why is Swagger-UI unable to see the version field in my OpenAPI specification?
I am trying to setup Swagger UI to display an OpenAPI specification provided by PostgREST. Unfortunately, I get the following error:
Unable to render this definition
The provided definition does not ...
- reputation score 95