Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

anyone do a write-only RLS policy? I'm trying to make a simple insert only policy and it seem to fail with ```new row violates row-level security policy for table```

I ran into this.  It’s because insert update and delete return the record by default and thus need a select policy.  The solution is to add the `returning: minimal‘ parameter to your `insert()` call.

https://supabase.io/docs/reference/javascript/insert

```
By default, every time you run insert(), the client library will make a select to return the full record. This is convenient, but it can also cause problems if your Policies are not configured to allow the select operation. If you are using Row Level Security and you are encountering problems, try setting the returning param to minimal.```

ahhh ok. I was GOING to try that but seeing "minimal" made me think it would run a "minimal" select query. I figured by default insert would not run a query.

This comes up so often I’m considering asking the team if maybe we should return minimal by default 🙂

Agreed with <@!845250139706753044> , we should change this as part of https://github.com/supabase/supabase-js/issues/170

It’s in the docs but it’s certainly not clear enough.  It should be spelled out: 

`If you’re using RLS then your user needs to have select access to the data if you want to be able to insert, update, or delete unless you use returning: minimal to override the default behavior.`

<@!845250139706753044> how do I write this `The solution is to add the returning: minimal‘ parameter to your insert()`? Do you have an example by any chance?

You just add an extra parameter to your insert command.  For example: 
```
    const { data, error } = await supabase
    .from('tablename')
    .insert([
      { 
        name: 'mark',
        age: 123
       }
    ],{returning: 'minimal'});```

Hmm, I am trying to do the same but I am using the C# Supabase NuGet Community Package and it's not working...

Sorry I’ve never used the C# library- you might want to hit up the maintainers and ask them about this.

Sure, thank you <@!845250139706753044>. I got it working by disabling the RLS altogether for now. Although, will this be a security concern or issue?

Yes you shouldn't turn off RLS.  Can you just give full read (`select`) access for that table?  That should fix it.

<@!383983705892454401> hey man - saw you were asking for the return feature in the c# code, just added it into the repo for postgrest-csharp and am rolling it into the supabase main lib right now