@User use this website, it's great

How would I set up a function in plpgsql that checks to see if a row already exists and then executes procedures conditionally based on that query?

In one of my tables I want a column that contains an array. I've defined it as

categories text[] not null,

. Table creates successfully, but if I try to enter values directly in the supabase dashboard everything I try is an invalid array? Ultimately I want to input something like this from my JS:

["this + that", "and", "another"]

. What does this translate to in the dashboard? The psql docs (https://www.postgresql.org/docs/9.1/arrays.html) say to use

{}

and quotation marks but these all give

Invalid Array

I have no idea what changed, but it now works with exactly what I started with...

["this + that", "and", "another"]

plpgsql

How can I assign the auth.uid() to a row for example to created_by?

BEGIN
  NEW.created_by = auth.uid();
  RETURN NEW;
END;

-> Error: more than one row returned by a subquery used as an expression

try

:=

?

although it shouldnt make a difference...

same error :/

Hey! I'm new to Supabase and I'm using for a side project. That project let users review their day (like a journal). So I have a reviews table and RLS policies were easy to implement (users can only read/write their own reviews). But now I'd like users to be able to become a member of a group. Once in a group, everybody can view each other's reviews. The problem I have is to write the RLS policy so that group members can only view each other's reviews. I followed this example https://supabase.io/docs/guides/auth#policies-with-joins, but when I tried my policy, a user could access all reviews (even from other group). Could somebody share a minimal demo of that RLS policy, in the same fashion as in that doc example?

The issue we have is we have to implement our own roles, and not use the postgres ones, because the users are auth.user

so I mirrored the auth.user table with a trigger, and am now in the process of working through how I am going to make my own custom roles

RLS with select query

EVEN BETTER

for people figuring out how to do auth and roles etc, I'm finding https://github.com/supabase/supabase/blob/master/examples/nextjs-slack-clone/full-schema.sql a really useful reference

just curious anyway to see the code for auth.uid()?

You can see it here https://github.com/supabase/supabase/discussions/2986#discussioncomment-1251406

Thank you

Anyone had issues with foreign key relationships after renaming a table?

I needed to remove the foreign key reference from the table, delete the respective column, create a new column and make it a foreign key again. The problem was solved after that. Hope it this works for you

i'm having trouble setting up a one to many relation, my lack of sql experience isn't helping here 😅 here are my tables (the relevant properties): buckets: id: uuid, columnIds: uuid[] columns: id: uuid i want to set up a relation on columnIds pointing to columns.id here's what I try, and I get the error "Error updating foreign key: foreign key constraint "buckets_columnIds_fkey" cannot be implemented"

(hopefully it's not confusing calling my table "columns" but I can't think of a better name lol)

That is definitely a confusing name for a table lol

What are you trying to achieve? I'm struggling to follow

Making something 1:many in psql should just be adding something like below into the "child" table.

bucket_id uuid references buckets not null,

E.g.

sql
CREATE TABLE buckets (
  id uuid generated by default as identity primary key,
  name text,
);

CREATE TABLE columns (
  id uuid generated by default as identity primary key,
  bucket_id uuid references buckets not null,
  name text,
);

You don't need to use uuid for every id, only use it when you really need it

Often a

bigint

is enough - but happy for someone to teach me otherwise 🙂