Having abit of an emergency here and already on pro plan

I'm trying to implement a RLS policy using the following "Using expression": >

auth.uid() in (
>   select   profile."userId"
>   from     profile, "_profileToteam", project
>   where    profile.id = "_profileToteam"."A"
>     and    "_profileToteam"."B" = project."teamId"
>     and    project.id = id
> )

but I'm getting the error: > Error adding policy: column reference "id" is ambiguous My understanding from the documentation here: https://supabase.com/docs/guides/auth/row-level-security that the "id" would be the project id. Why is it "ambiguous" or is referring to something else?

RLS ambiguous column

Hey Guys! I just deployed supabase via docker with the default docker-compose and .env files and When i go to localhost:3000 -> default project -> api i get this screen

Chrome console error:

any ideas?

Managed to solve it by running:

sudo echo "127.0.0.1  kong" >> /etc/hosts

Is there any way to sync RLS policies for local development?

Syncing RLS policies

How to delete the Supabase API logs? They have become so massive that I've exceeded my project size and Supabase stopped working

there is log retention period i suppose

Supabase API logs

hello any supabase expert here to help me answer a question ?

i am totally new to supabase and i have a question

it's best to ask your question in the #843999948717555735 channel and start a new thread for it - that way someone who knows the answer to your question can see it and reply to it

thank you chipilov gonna ask in the help section

i remember when there was 20gb storage 😔

hello 👋 why

geometry

fields (postgis) are returned as GeoJSON but

geography

fields are returned as WKB strings? is it possible to force geojson?

Encountered the same issue and went with this eventually: >

> CREATE OR REPLACE FUNCTION geography_to_geojson(geography) RETURNS json AS $$
>   SELECT extensions.ST_AsGeoJSON($1)::json;
> $$ LANGUAGE SQL;
> 
> CREATE CAST (geography AS json) WITH FUNCTION geography_to_geojson(geography);
>

phone auth persistence doesn't work as many have reported because the session object returned from the

verifyOTP

doesn't have `expires_at`field https://github.com/supabase/gotrue-js/blob/master/src/GoTrueClient.ts#L707

if (this.persistSession && session.expires_at) {
      this._persistSession(this.currentSession)
    }

For things like this, I think it's best to open an issue on GitHub repo

Is there any limit for concurrent connections to supabase real-time?

Concurrent real-time connections

Sorry to bump a PR in here, but I opened a PR about a month ago in supabase-cli to add a dry-run flag to the db push command: https://github.com/supabase/cli/pull/161 I've used this every time I've done a db push since and would really love to get it merged so I'm not running a fork! Is there any chance it could get a review from a maintainer when you have a chance? 🙂

Hi, did you able to mange connect it from localhost? I am facing CORS issue. Also this page is is having error code 500 issue. Your command is returning access denied. Any idea?

postsqresql time -> ts

Date

? @Field({ nullable: true }) @Column({ type: 'time', nullable: true, default: null }) time?: Date;

@bluetoothfx you ran it with sudo and got access denied?

after logging with root I have executed but no luck

The problem is, as far as i understand, that it redirects to http://kong , but you probably don't have a dns entry for kong in order to resolve it to an actual address

That is, at least, what fixed it for me