LEGEND
07/03/2022, 3:07 PMKelaos
07/03/2022, 3:27 PMomar
07/03/2022, 5:25 PMdeclare test_table(payment_id integer, booking_id integer);
begin
INSERT INTO public.payment(user_id, session_id, amount, status)
VALUES (userid, sessionid, price, event_status)
RETURNING id into test_table;
INSERT INTO public.booking(user_id, session_id)
VALUES (userid, sessionid)
RETURNING id into test_table;
return test_table;
end;
React noob
07/03/2022, 6:13 PMCory
07/03/2022, 11:25 PMLEGEND
07/04/2022, 3:40 AMInASunshineState
07/04/2022, 4:38 AMLEGEND
07/04/2022, 8:17 AMKayden
07/04/2022, 12:50 PMkbsali
07/04/2022, 2:03 PMhttps://OUR_URL/redir#error_code=404&error_description=User+not+found
This is a sveltekit project. Here is the code snipper used to generate the password reset flow which used to work as expected :
js
export const post: RequestHandler = async ({ request, url }) => {
const { email } = await request.json();
const body = await supabase.auth.api.resetPasswordForEmail(email, { redirectTo: `${url.origin}/redir` });
return { body };
};
Any help appreciated, this is very annoying for our members.Kelaos
07/04/2022, 4:17 PMconfig.toml
ever pushed to the Supabase cloud instance or are the values purely for local dev?
In particular the site_url and external OAuth secrets being in there made my want to be extra carefulGitanes
07/04/2022, 4:35 PMThere is no unique constraint matching given keys for referenced table
. How should I do it?NARCISO
07/04/2022, 4:38 PMCory
07/04/2022, 7:00 PMweilzuvielgewalt
07/04/2022, 8:23 PMconst { data, error } = await supabase
.from('studios')
.insert([
{ id: letMeHandleTheIncrementForYouFunction(), other_column: 'otherValue' },
])
Needle
07/05/2022, 12:25 AMCory
07/05/2022, 4:08 AMNeedle
07/05/2022, 5:50 AMeqoram
07/05/2022, 10:06 AMZedem2437
07/05/2022, 12:06 PMEdditoria
07/05/2022, 12:44 PMlet sum = new Function('a', 'b', 'return a + b');
console.log(sum(1, 2));
I think Edge Functions won't allow this. Can I overcome this problem?Kayden
07/05/2022, 2:09 PMnischal012
07/05/2022, 2:53 PMcy
07/05/2022, 3:34 PMid
column before inserting the new data batch. I created a SQL function:
CREATE OR REPLACE FUNCTION truncate_xoxo()
RETURNS void
LANGUAGE sql
AS $$
TRUNCATE xoxo RESTART IDENTITY;
$$;
Unfortunately, when I call supabase.rpc("truncate_xoxo")
I get an error: "must be owner of sequence xoxo_id_seq".
I checked the pg_sequences
table and the xoxo_id_seq
is owned by supabse_admin
.wiesson
07/05/2022, 3:39 PMon delete cascade
actually works and I needed to restore a backup from yesterday. Does anyone know if I filter the supabase logs so that I could retrieve some data from inserts and updates that happened today? π€Blade
07/05/2022, 4:45 PMsupabase-community/auth-helpers
for SvelteKit. It doesn't seem to ever resolve the callback fetch call and I don't know why. I followed the example (https://github.com/supabase-community/auth-helpers/tree/main/examples/sveltekit) but to no avail.amitmirgal
07/05/2022, 5:07 PMcurl '<SUPABASE_URL>' \
-H "apikey: SUPABASE_KEY" \
-H "Authorization: Bearer SUPABASE_KEY"
I am getting the below data in response
{"message":"permission denied for schema public","code":"42501","details":null,"hint":null}
Do I need to turn on any config?Needle
07/05/2022, 7:31 PMabaum
07/05/2022, 7:36 PMedge_logs
and postgres_logs
tables in the Logs Explorer? we've been trying to reconcile some requests that are failing, and so far it seems that the response code lives in the edge_logs, and the authorization/header data lives in the postgres_logs, and I haven't found a clean way to connect them other than by timestamp.liljamesjohn
07/05/2022, 7:51 PM