If I try to use

auth.signIn()

with a none existing email for the magic link. An error 500 is returned

Database error saving new user'

Just double checking if this a bug error message? I don't think users should attempted to be saved using the signIn functions

Hey all, does anyone know how to sort by date inside JSONB? My JSON looks like the below:

json
{
  "live": false,
  "notificationItems": [
    "NotificationRequestItem": {
       "eventDate": "2021-08-09T14:19:49+02:00"
    }
  ]
}

Trying to figure out how to order it as its inside an array, but the array item only ever contains 1 item. Assuming I need to convert it somehow but unsure how to do this?

js
.order("data->notificationItems->NotificationRequestItem->eventDate", {
          ascending: false,
        });

Is there a way to have multiple tables for user authentication? To be able to have the same email in both tables (cover multiple services) in one project.

Hey folks! Any ideas around how to implement Stripe payments when the BE is done on Supabase? Im using NextJS for the frontend.

Stripe

Hello everyone, Im a little new to Supabase. I am currently using Auth to allow users to sign up through Discord. I would like to extend the session data that is returned when I run the code below

js
const { data: user, error } = await supabase.auth.api.getUser(
    req.cookies["sb:token"]
 );

I would like to add the users access token returned by the provider as i need it to interact with Discords API

Hey everyone! Does anybody have experience with using Supabase / Expo using OAuth? The example project uses username + password, but I found this section in the docs: https://supabase.io/docs/reference/javascript/auth-signin#sign-in-using-a-refresh-token-eg-in-react-native This works locally, but when I run this app in TestFlight it throws an "invalid redirectUrl" error. What URL do I need to add to my Supabase allowlist? i.e... What's the output of

AuthSession.makeRedirectUri({ useProxy: false })

?

I could (and will) just render it out but I wanted to ask here in case there's something else I need to keep in mind

I am trying to call a stored procedure with arguments, but I am getting type cast errors and it isn't finding the function.

const { data, error } = await this.database.rpc('boostPool', {
      pool_name: pool,
      amount: Number(newBoost)
    })

function public.boostPool(amount => text, pool_name => text) does not exist

We are having trouble with Azure auth on supabase. We are getting an error after login: ?error=server_error&error_description=ERROR%3A+permission+denied+for+table+audit_log_entries+%28SQLSTATE+42501%29#/authentication

Hiya! I am having some issues with my auth flow. (this may be more at home in sql, but it may not) When I attempt to authenticate with Azure (note this is a single DB, others work fine) I saw:

{
  "message": "An invalid response was received from the upstream server"
}

I found in the logs that a migration was failing. It was trying to create the column confirmed_at on the auth.users table. But it already existed. So I nuked the column, allowing the migration to happily go on its way. BUT THEN! I had a new issue. When I attempt to login using Azure auth I get a new error message:

permission denied for table audit_log_entries

. Ok so I browse my users and permissions and I see that there's only 1 user, the user made by supabase. I attempt to manipulate the table via postgres client. It works fine. Hmf. Dead end. I try granting permission to the user, you know, just in case. No change. So, what user is it trying to manipulate this table with, how did it get this user, and how do I fix it? Also, how did all of this happen? For anyone who may find this in the future. The issue is my backup manipulating the auth schema. Exclude the auth schema from backups unless you know what you're doing 😄

Has anyone here used the c# wrapper?

Is it possible to update a projects password?

nvm found it 😆

I think all functions are lowercase named I also had a problem with argument order Try single argument func

Figured it out. Stored procedures are not supported had to use functions.

Docs say stored procedures though so confusing.

Yeah I agree

You should update the docs 🙂

Why me I didn’t make it.

Still trying to figure this stuff out myself.

Takes 5 seconds and helps the next person out

Open source etc

Took a lot longer than 5 seconds, and rarely do these get approved but here you go.

I'm guessing you didn't surround the function name with quotes when creating the function (see https://github.com/supabase/supabase/discussions/2896). FTR, Postgres functions (i.e.

CREATE FUNCTION

etc.) are exactly the Postgres-speak for "stored procedures", though technically there's also

CREATE PROCEDURE

that's less commonly used.

can someone show an example on how i would update a column of a table that is an array of json type? this column has multiple ojbects and how i would i delete/add to this array?

documentation only shows updating normal json objects but not [] json

Hello partners! How and when are you renewing the access token? I currently have a problem, I have 2 access points to supabase, 1 from the frontend and another from a resource server, the problem is that on the front, when an access token expires, the supabase api keeps returning data and does not It says nothing about that it has expired, but on my resource server trying to get the user's information through the token, it tells me that it has indeed expired. It is strange why before in the frontend (a few days ago) when I got an error when obtaining the user's information, it automatically launched the logout, but now that does not happen, because it seems that it does not expire. Any idea why this happens?