I'm calling the functions here to "Generate links to change current email address" and no email is getting sent. I tried: - Custom SMTP - The default SMTP - Calling both functions together vs. calling one or the other - Using the

redirectTo

option It seems like no emails have been sent after 10+ attempts. Is there something I'm missing?

So I built this simple svelte auth component using guide here https://supabase.com/docs/guides/getting-started/tutorials/with-svelte. But I also want to give user the ability to just enter the code

{{ .Token }}

sent in the email so they don't need to click the link in the inbox. Type seems to support this, but I'm not sure how do I rewrite the function? Do I check if the code var exists and then pass it with

signInWithOtp({})

? That don't seem to be expected...

I was wondering if it is possible to self host Supabase without the use of Docker? I am particularly looking to run it on OpenBSD. Any info would be greatly appreciated.

When I try to run my edge functions via

supabase funcions serve

they crash when any code accesses some node globals such as

performance.now()

. They crash because the global

performance is undefined

The strange thing is that the same code works perfectly fine when running locally with

deno run -A ./my_code.ts

. It's only the edge runtime that for some reason seems to be missing Deno builtin globals like

performance

. Am I missing something? Is this a bug in the edge runtime? It it expected but just not documented? Any pointers would be appreciated, thanks!

Hi, I want to use the new string filters (e.g. startsWith). Any idea when this will be available in existing supabase projects?

When I run this command

supabase db diff --use-migra

I get a long error (attached). My supabase CLI:

1.42.7

I disabled

ufw

, but still no difference.

Any plans to implement a data explorer ala Hasura to visually build queries?

Is there any additional configuration required for docker to make this work on gitpod? People seem to be reporting that they're happily using gitpod but I get the error I've attached, when trying to run

supabase start

Hey guys, during the last hour I'm constantly getting the error "This project does not exist" on the supabase cloud platform. I'm signed in and my account is in good standing. What might be the reason?

In my use case, I have both Supabase running as well as an express app (for business reasons edge functions is not enough). I'm fine not being the one generating the JWT but it would be helpful to get a some sort of callback when a user first registers their account and/or when they login. I understand there are webhooks and functions but, not only they are in ALPHA stage but I would preferably not open a route (endpoint) for this usecase. DB functions would not scale for this specific use case either. I'm wondering if subscribing to the users table is the optimal way to go or it would consuming too many resources since the server instance(s) would be taking a connection. The way I see it, the webhook is probably the best approach but would love to hear other opinions.

Hi all, Wondering if anyone has run into a similar issue when attempting to use

supabase db remote commit

to pull down changes from the remote db. When running this command, I receive the following error: > Error: Error running pg_dump on remote database: Error response from daemon: operation is not permitted on predefined host network I've tried resetting docker to factory defaults and still no luck, and not really sure what to do to troubleshoot further. I have Docker Desktop for Windows (using WSL 2). I've also attached the full output when using the

--debug

flag with the command. Thanks for any help!

I wonder what the correct way to do this is. i haven't found much information on how to persist state from the provider hooks and make it persist. react apps forget all the context on reload, so if the local state changes and its something i want to persist, like darkmode/lightmode or prefered language, what would be right pattern to do this with supabase and nexjts?

Hello, I am using this resetPasswordForEmail() like this:

const { error } = await supabaseClient.auth.resetPasswordForEmail(
      data.email,
      {
        redirectTo: `${getURL()}/reset-password`
      }
    );

However, when i receive email link, I am logged in and redirected to home page instead of

reset-password

I am working with Supabase auth, I was trying to login using Google. I am not sure why it's not working I am getting this error

json
{
  "message":"No API key found in request",
  "hint":"No `apikey` request header or url param was found."
}

I am currently the Owner of my project and I am trying to run my sql file from my cmd psql but its throwing this error: psql:db.sql:2401: ERROR: permission denied to create event trigger "issue_graphql_placeholder" HINT: Must be superuser to create an event trigger. ALTER EVENT TRIGGER psql:db.sql:2412: ERROR: permission denied to create event trigger "issue_pg_cron_access" HINT: Must be superuser to create an event trigger. ALTER EVENT TRIGGER psql:db.sql:2423: ERROR: permission denied to create event trigger "issue_pg_graphql_access" HINT: Must be superuser to create an event trigger. ALTER EVENT TRIGGER psql:db.sql:2434: ERROR: permission denied to create event trigger "issue_pg_net_access" HINT: Must be superuser to create an event trigger. ALTER EVENT TRIGGER psql:db.sql:2444: ERROR: permission denied to create event trigger "pgrst_ddl_watch" HINT: Must be superuser to create an event trigger. ALTER EVENT TRIGGER psql:db.sql:2454: ERROR: permission denied to create event trigger "pgrst_drop_watch" HINT: Must be superuser to create an event trigger. ALTER EVENT TRIGGER It's saying I am not a superuser so, how can I be a superuse

When I start my app I get the following error:

Hi, I'm trying to create a webhook in my local development environment, but when I try I get this error and I don't know how to fix it, someone can help me?

Hi, I try to setup a cron job from my app but when I try to call alter_job I get a permission denied error. The RLS functions seam to be correct and the schedule function works fine. Is there something I could have missed that blocks authenticated user from altering a job?

I've got a microservice built on C# where I would like to verify requests from the FE application to check if the user is both authenticated and authorized to interact with this microservice. What I would like to do is to send the current sessions access token from the FE application to the microservice, where it verifies the token and the user by calling the Supabase auth endpoint and basically checking

isValidToken(token)

. But I'm unsure how to access this from my C# code. I haven't been able to find out if I can directly call auth endpoints of my Supabase instance, like for instance

/verifyToken

(or similar). Do I need to build a "translation service" that uses the official libraries so I can use something like

supabase.auth.api.getUser('ACCESS_TOKEN_JWT')

which returns if if there is an active session. I haven't been able to find an equivalent solution in the C# community library. Is there a better/easier way to solve this problem?

Hello! I'm trying to use .remove() but when I call it nothing happens. No data or errors are logged when I call it. I checked to make sure I had my rls setup and everything looks good to me at least. Any help would be much appreciated! Code:

ts
const { data, error } = await supabase.storage
  .from('avatars')
  .remove([`${user.id}/small.png`, `${user.id}/medium.png`, `${user.id}/large.png`])

Delete Policy (authenticated):

sql
((bucket_id = 'avatars'::text) AND ((storage.foldername(name))[1] = (auth.uid())::text))

Hi! I have a foreign table defined this way:

-- Create foreign data wrapper to fec
CREATE EXTENSION postgres_fdw;
GRANT USAGE ON FOREIGN DATA WRAPPER postgres_fdw TO postgres;
CREATE SERVER fec FOREIGN DATA WRAPPER postgres_fdw OPTIONS (
  host '...hostname...',
  port '5432',
  dbname 'postgres'
);
CREATE USER MAPPING FOR postgres SERVER fec OPTIONS (
  user 'postgres',
  password '...password...'
);
-- Create foreign table
create foreign table indiv14 (
...ddl....
);

And there is a compound (btree) index in indiv14, so that locally it uses an index scan:

EXPLAIN VERBOSE select * from indiv14 where name='sdfsdf' limit 25;

Limit  (cost=0.43..10.47 rows=8 width=148)

  ->  Index Scan using indiv14_name_zip_code_idx on public.indiv14  (cost=0.43..10.47 rows=8 width=148)

        Index Cond: ((indiv14.name)::text = 'sdfsdf'::text)

Query Identifier: -2987151377721656964

But when I use the foreign data wrapper, I get a scan:

Limit  (cost=100.00..111.67 rows=1 width=596)

  ->  Foreign Scan on public.indiv14  (cost=100.00..111.67 rows=1 width=596)

        Remote SQL: SELECT cmte_id, amndt_ind, rpt_tp, transaction_pgi, image_num, transaction_tp, entity_tp, name, city, state, zip_code, employer, occupation, transaction_dt, transaction_amt, other_id, tran_id, file_num, memo_cd, memo_text, sub_id FROM public.indiv14 WHERE ((name = 'sdfsdf'))

Help

Hi, I'd like to manually change the email address of one of my users in a supabase.com-hosted Supabase project. They signed up using the basic email auth provider. I'd like to change the address myself without having to involve the user. At least in the UI I can't seem to be able to edit the

auth.users

table. and the Users overview doesn't allow for an email change. How can I do it?

i use this to pass custom headers to Supabase query.

ts
export const useSupabaseTest = (capgkey: string) => {
  const options: SupabaseClientOptions<'public'> = {
    global: {
      headers: {
        capgkey,
      },
    }
  }
  return createClient<Database>(supabaseUrl, supabaseAnonKey, options)
}

That allow me to check the capgkey in RLS with

sql
(current_setting('request.headers'::text, true))::json ->> 'capgkey'::text)

That work like a charm. Sadly with realtime query the RLS prevent the event to be broadcast. i tried to follow what is said here: https://supabase.com/docs/guides/realtime/postgres-changes#custom-tokens and updated my code like that

ts
export const useSupabaseTest = (capgkey: string) => {
  const options: SupabaseClientOptions<'public'> = {
    global: {
      headers: {
        capgkey,
      },
    },
    realtime: {
      params: {
        capgkey,
      },
    },
  }
  return createClient<Database>(supabaseUrl, supabaseAnonKey, options)
}

I can see in my front capgkey is sended but the broadcast still not happen. Do someone know how to handle this case, or at least how to inspect logs on Supabase side to know whats happening ?

its really hard to figure out whats going on, please help. I've got this few lines of code, const { createClient } = require('@supabase/supabase-js') const supabaseAdmin = createClient(URL, KEY) supabaseAdmin.rpc( custom function, params) but it throws the error on title... i've already double checked all types, might it be because im not using an ES6 import? or because not using ts? all param are of the correc type, like a vector of strings a double and an integer.

Just curious if anyone has any examples of using Prisma + Supabase + Supabase Auth?

I've been following the next13 server component walkthrough and I can't figure out why the access token is displaying in the url. I can provide code as needed but I've just walked through the whole process and the only difference is I am using the github provider and signing in with OAuth which is attaching the full access token to the url. It's probably some understanding I don't have with how OAuth works but would love to understand 🙏

I run: $

source .env && prisma migrate dev

Environment variables loaded from .env Prisma schema loaded from prisma\schema.prisma Datasource "db": PostgreSQL database "xxx@db.xxx.supabase.co:5432/postgres", schemas "public" Error: P1001: Can't reach database server at `localhost`:`5432` Please make sure your database server is running at `localhost`:`5432`. [1]+ Done DATABASE_URL=postgresql://postgres:xxx@db.xxx.supabase.co:5432/postgres Larry@ASUS MINGW64 /c/__repos/_wip/pinz.ai (main) $ source .env && prisma migrate dev Environment variables loaded from .env Prisma schema loaded from prisma\schema.prisma Datasource "db": PostgreSQL database "xxx@db.xxx.supabase.co:5432/postgres", schemas "public" Error: P1001: Can't reach database server at `localhost`:`5432` Please make sure your database server is running at `localhost`:`5432`.

NOTE

I CAN connect to db using datagrip. I SEE db in SB Dashboard. My schema.prisma partial:

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["multiSchema"]
}

datasource db {
  provider = "postgres"
  url      = env("DATABASE_URL")
  directUrl= env("DIRECT_URL")
  schemas  = ["public"]
}

I have experienced issues with Dashboard involving messages like:

Problem access project statistics

,

Project doesn't exist (top right toast)

,

duplicate project names

. Currently unable to proceed.

I want to create a policy to make sure only the

approved

column on my

relationships

table can be updated if it has not already been approved. This is what I have but I run into this error:

Error adding policy: failed to create pg.policies: missing FROM-clause entry for table "new"

Hello! I made a thread in the Deno Discord about this same topic, but my gut tells me this is an issue with the Supabase client library and not Deno. I have a script that looks like the following:

import "https://deno.land/x/dotenv@v3.2.2/load.ts"
import { createClient } from 'https://esm.sh/@supabase/supabase-js@2.10.0'
import { ensureDirSync } from "https://deno.land/std@0.178.0/fs/ensure_dir.ts"
...
const supabaseUrl = Deno.env.get("SUPABASE_URL")
const supabaseKey = Deno.env.get("SUPABASE_KEY")
const supabase = createClient<Database>(supabaseUrl, supabaseKey)
...
const doDownloads = async () => {
  // getting storage download paths
  console.log(Deno.resources()) // { "0": "stdin", "1": "stdout", "2": "stderr" }
  
  const { data, error } = await supabase
    .from('myTable')
    .select<'*', RowType>()
  
  console.log(Deno.resources()) // { "0": "stdin", "1": "stdout", "2": "stderr", "3": "timer" }

  // ensures dir exists with ensureDirSync then downloads with supabase.storage
}
...
doDownloads()
  .then(() => {
    console.log('Downloads complete!')
    console.log(Deno.resources()) // { "0": "stdin", "1": "stdout", "2": "stderr", "3": "timer" }
  })
  .catch((err) => {
    console.error(err)
    console.log(Deno.resources()) // { "0": "stdin", "1": "stdout", "2": "stderr", "3": "timer" }
  })

console.log('Downloading...')
console.log(Deno.resources()) // { "0": "stdin", "1": "stdout", "2": "stderr" }

export {}

Ran with

deno run --allow-env --allow-net --allow-read --allow-write deno/doDownloads.ts

So as shown in the comments in the code, the

.select

query from the

supabase

client creates some timer resource that is not cleaned up properly. This is an issue because the script will hang/will not exit after being ran, unless I add

Deno.close(3)

to the

.then

and

.catch

functions. This does not occur when I convert the script to Node.js, but I have no way of knowing if this is a Deno transpilation or Supabase client issue.

I'm using supabase CLI locally and I've created a public bucket on my project. The problem: when setting up the project the very first time, or when resetting the DB via

supabase db reset

, the buckets are gone. I'm wondering if there's a simple way to persist it from the command line, like with the public schema and its migrations files. If not: what best practice do you suggest? I was thinking about pg_dump it in binary and add the output on my project.