I have this trigger:

create or replace function public.handle_new_user()
returns trigger as
$$
  begin
    insert into public."User" (id, email, userType)
    values (new.id, new.email, new.raw_user_meta_data->>'user_type');
    return new;
  end;
$$
language plpgsql security definer;

drop trigger if exists on_auth_user_created on auth.users; 
create trigger on_auth_user_created
  after insert on auth.users
  for each row
    execute procedure public.handle_new_user();

But I get a 500 on user signup. I can see the user_type field in the auth panel. My only guess is that

userType

in the

User

table is an enum, but I don't know how to cast it properly

I am trying to use Twitter Authentication with supabase, but am running into the classic

http://localhost:3000/?error=server_error&error_description=Error+getting+user+email+from+external+provider

error. All fixes to this issue say that I should obtain elevated status, but the same error is happening even after obtaining elevated status from Twitter. I am able to send the user to the Twitter Flow, but upon redirect I get the

Error+getting+user+email+from+external+provider

error. Any help would be appreciated. Edit: Here is some more information. Seems like it works for others. https://github.com/supabase/supabase/discussions/5915

Such as Auth and Storage. The motivation is to reduce bundle size

Hi all I have a spec where I want a function that updates a value in my supabase real time database periodically or on demand. So if a user does a particular thing it updates, but if nothing happens it then falls back to the action done at the periodic interval. Is this possible? I haven't found anything on the internet related to this, it seems that it will require another edge function, but that's as far as I've gotten, thanks.

Some wonderful person posted this in the github community. > The docker-compose.yaml for the db container has the default volume path of - ./volumes/db/init:/docker-entrypoint-initdb.d. This creates the database when starting up the container but if noone changes that, it means, this will always be repeated on every start. The compose file has the comment value # - ./volumes/db/data:/var/lib/postgresql/data. So I copied the previously created container from /var/lib/docker/ to that path, removed the init volume path, uncomment the other and after the next docker compose up -d the database was there again. 🙂 I don't this part

So I copied the previously created container from /var/lib/docker/

I unable to find the location of the database files to move them into my created folders

./volumes/db/data:/var/lib/postgresql/data

where is my database located? I don't want to lose my data each time I update.

Hi, is there a way to attach a debugger to locally served edge functions like you can in Deno? https://stackoverflow.com/questions/61853754/how-to-debug-deno-in-vscode https://deno.land/manual@v1.25.2/getting_started/debugging_your_code

I have deep linking working in my react native application currently, however I am having issues with third party apps requiring a return url that starts with http. For supabase I was able to just give them my deep link url of betabridge:// and it worked. I tried to create an edge function that redirects to betabridge:// but it only accepts post requests so it will not work. I would rather not spin up a site or server just for this as I am tring to go to market as quickly as possible. Is there any way to achieve this?

Do we have to use

setAuth()

on our current SupabaseClient Object once we receive the

SIGNED_IN

Event with its

session.access_token

, or does the SupabaseClient Object updates itself through the

signIn()

process? Asking to be sure because it looks like my API calls still seem to use the anon access token post signIn()

App hosted on Vercel, using Next.js and Prisma - configured to use the connection pooling URL currently hitting this - connection limit hasn't been reached from what I see Can anyone help with this please? Full error message:

Error querying the database: db error: FATAL: no more connections allowed (max_client_conn)

What are minimum recommended VPS requirements for self-hosting? I wonder what is the starting point in terms of CPU and Ram

I'm hoping to create a trigger that fires when the email_confirmed_at field is updated in the auth.users table BUT only if the invited_at field is NOT NULL. If this is possible I'd appreciate some hints.

Has Supabase said how Postgres updates happen? My current instance is on 14.1, but I believe that 14.5 is the latest.

Hey yall, are there some docs about reseting passwords for users who used only phone auth? I'm seeing this rn but doesn't seem to work for phone auth: https://supabase.com/docs/reference/javascript/auth-api-resetpasswordforemail thanks 🙂

So I upgraded to the RC version of JS - and now I can't log in from my code. I'm playing around on my laptop at the moment so I just want to be able to log in using a hard coded email and password, and then use that session to make RPC calls to Supabase. But my code isn't working. I wrote a database function to return the current user and role, and it's returning null and "anon". Here's my login code. I'm sure it's something really stupid.

import {createClient} from "@supabase/supabase-js";

let client = createClient(
    'http://supabase.example.com/',
    'supabase-anon-api-key',
);

const { data, error } = await client.auth.signInWithPassword({
    email: 'user@example.com',
    password: 'random-password',
})

if (error != null) {
    throw error
}

let userinfo = await client
    .rpc('userinfo', {})

console.log("Got userinfo", userinfo)

// prints: {
//   error: undefined,
//   data: { uid: null, role: 'anon' },     <-- this should be role "authenticated"
//   count: undefined,
//   status: 200,
//   statusText: 'OK'
// }

I'm currently evaluating Supabase Storage vs. Cloudflare Images for hosting around 10,000 photos for our website. The main argument for CF Images is that they have transformations (variants). On the negative, I would need to have my domain in CF to be able to set Cache-Control. And in general I'd like to stick to Supabase where possible. Is there even a super rough estimate when Storage Transformations will be available? 1 month? 2 months? 4 months? More? Will it be possible to set up pre-defined variants (as opposed to providing the parms in the URL each time, like ?w=800&h=600)?

I want to use the meta api in the version, build tables and columns. Is it possible? if so how? Is there a NOSEJS client for that? Thanks

I'm semi confident this is okay because when creating the client it uses the project url which is https along with the public api key for the project, but wanted to double check as I'm not 100% knowledgeable on these things under the hood.. I typically enforce https when hosted, but out of curiosity same question for websites accessible through http?

I got a table named

companies

with RLS enabled. I created a policy to allow SELECT for any authenticated user + anon. I do my API call from my Vuejs client with an authenticated user :

js
const { data, error } = await supabase
        .from("companies")
        .select(
          "id, nom, raison, adresse, cp, ville, pays, id_name, uuid, resipay"
        );

I check my API call live on the XHR console and the authenticated token is in the header. Yet I get a 403 response from supabase... What did I miss?

I’d like to check for the

access_token

cookie server-side, for example in Next.js

getServerSideProps

via the

context.req.cookies

argument. Depending on the existence and validity of the

access_token

, I’d like to serve either protected content or redirect the user. But

gotrue-js

doesn’t seem to save the cookie on the client automatically. Is there a recommended way to do this? I noticed that @alaister proposed a new setup for [

supabase/auth-helpers

](https://github.com/supabase/auth-helpers/pull/239) where

withPageAuth

has the Supabase client read the request/response headers for a cookie and uses that to set a session server side. But for that cookie to be sent by the browser to my app, say app.vercel.com, I need to first have something save the cookie. The responses from the Supabase Auth API do come with a

Set-Cookie

header that holds the

access_token

, but the

Domain

attribute is set to the Supabase project URL (

<xyz>.supabase.co

) — which means this cookie is not passed to my app’s server. I see two options to address this: 1) Save the cookie on the client in an

onAuthStateChange

callback, which will set the cookie’s domain to be the same as the app server.

gotrue-js

doesn’t seem to set any cookies on the client, so we’d do that ourselves. 2) Route the login traffic through an API route so that the

Set-Cookie

header with an access token comes from my app’s domain. Am I missing something obvious here? How do you ensure that the

access_token

gets passed in the cookie when calling your app server and can be used to set up a session in

getServerSideProps

in Next.js, API routes, or in middleware?

As far as I know, you are legally required to host your database in the EU if you have users from the EU: "The GDPR requires that all data collected on citizens must be either stored in the EU" (https://www.archive360.com/blog/data-sovereignty-and-the-gdpr-do-you-know-where-your-data-is) Is there an option to have your supabase database hosted on EU servers to stay compliant?

Sometimes I just want a table-like result, as if I was trying to produce a view, except I want to feed it parameters. I know there's RETURN TABLE AS, RETURN TEXT AS, RETURN SETOF, etc. but knowing the full list of choices as well as how and when to use them -- I'm sort of lost. Supabase docs have limited direct query coverage for obvious reasons, but since it's a capability and it's all a wrapper, I am trying to learn more about Postgresql in general to inform my choices here. I just genuinely can't find anything in a search that explains it in a way that "registers."

Getting this error. I'm assuming this is something to do with localStorage. relavant stackoverflow issue https://stackoverflow.com/questions/68763589/undefined-is-not-an-objectevaluating-this-localstorage-getitem-error-in-reac can someone help me with this? I tried to clean localStorage too. didn't work.

Hi! As you may know, triggers and functions are not production ready within Supabase. How would one go about getting notifications (for use in python) with the operation as a payload? What I did was

cur.execute(f"INSERT INTO mydb (model, img, multi_dl) VALUES ('{model}', '{img}', '{multi_dl}'); NOTIFY test, 'placeholder';")

I'd like the placeholder to be the operation I just executed (intert into...). Any ideas?

When I try to use Supabase DB with Prisma, I get this error

When I try to follow this doc, https://supabase.com/docs/reference/auth-helpers/next-js, I just get authListener.unsubscribe is not a function...

We are starting a new project at work and are having consistent issues getting access to app.supabase.com. Primarily because github is the only way to authenticate. My personal email wa my primary github email but I was invited to supabase with my work email. Is there a way to completely detach github from supabase and regenerate my account?

More of a general SQL question than supabase. Im creating a marketplace and designing the schema that will hold my users

orders

. An order can have many

lineItems

. As I'm coming from firebase, I would just usually have an

order

document. It would have an

orderTotal

field. The

lineItems

would also be part of this

order

document. However, now that my db is relational and split into tables, is it best practice to store totals like I have done before or should I calculate the total price when selecting all my

lineItems

?

Hi there, I want to invoke an edge function that returns a buffer/blob of a created File. If I call the function via REST and save the output directly to a file it works great. But If I call the function with "supabase-js@2.0.0-rc.10" and trying to save the data-result the file is always corrupted. Any ideas what to do? Example snippet:

supabase.functions.invoke<Blob>('createInvoice', {
      body: { invoiceId: invoiceId }
}).then(res => FileSaver.save(res.data))

Best regards, Jan

I am about to deploy a large number of migrations. Before doing that i would like to test them one more time against prod database but on localhost. I have

pg_dumpall

my prod instance. Running

supabase start
pg_restore -cC -d postgres -e ./postgres.custom

gives

pg_restore: from TOC entry 3540; 1262 12974 DATABASE postgres postgres
pg_restore: error: could not execute query: ERROR:  cannot drop the currently open database

When i

psql

and

create database temp;
\c temp;
drop database postgres with (force);

I get

ERROR:  database "postgres" is used by an active logical replication slot
DETAIL:  There is 1 active slot.

but

pg_subscription

is empty. How can i restore a database from a backup?

I am working on a small app right now with NextJS that basically has 2 parts. There is a public/client facing landing page where information from the database will be displayed. The page will contain a basic message, contact information, and links to their social accounts. The other part is an admin only page (registered supabase users) with a form for creating new clients. I set up a table named "clients" that has all of the necessary columns (name, message, street, city) except for their social media links. I am a bit stuck on how to proceed with this at the moment. My first thought was to just have preset social columns in the table and have the form write directly to those. However, I am thinking I might run into some issue down the line where the I have not accounted for a type of account. Should I just use an array on varchar with objects, or is there a better way to go about this? I do apologize if this confusing. If any more clarification is needed please let me know!