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

Supabase

i get this ```{"code":500,"msg":"Error confirming user","error_id":"49602fde-488e-4910-aa34``` since last night

Where can I submit a bug issue for the supabase storage "editor"? It is minor but annoying. If I create a new storage folder, enter a name and hit enter in Safari, the whole page reloads instead of creating the folder. I guess, there is a ev.preventDefault() or sth like this missing (?)

I have a query like this

```js
  const { data, error } = await supabase
    .from("anime")
    .select(
      "title->userPreferred, recommendations!original_id(recommendations:recommend_id(*))"
    )
    .limit(1)
    .single();
```

it returns 
```json
{
  userPreferred: 'Dragon Quest: Dai no Daibouken',
  recommendations: [
    { recommendations: [Object] },
    { recommendations: [Object] },
    { recommendations: [Object] }
  ]
}
```

The expected output is
```json
{
  userPreferred: 'Dragon Quest: Dai no Daibouken',
  recommendations: [
    [Object],
    [Object],
    [Object]
  ]
}
```

What should I do, thanks

Hey! I have this plpgsql function:
```sql
CREATE OR REPLACE FUNCTION public.events_http_send_message_event(event_id uuid, dispatch_event_type event_type, bot bot_members, message messages)
    RETURNS http_client_response AS
$$
DECLARE
    res     http_client_response;
    headers http_header[];
BEGIN
    SELECT
           public.events_http_headers(event_id, bot)
    INTO headers;

    SELECT status, content_type, content::json->>'data' AS data, content::json->>'type' as type
        FROM http((
                   'POST',
                   bot.interactions_url,
                   headers,
                   -- Removed for brefiety
            )::http_request
        ) INTO res;

    RETURN res;
END;
$$ LANGUAGE plpgsql;
```
But it gives me this error, 
```
invalid input syntax for type integer: \"(200,\"application/json; charset=utf-8\",,)\"
```
Any help would be awesome!

I am not very familiar with plpgsql, but what is the definition of "http_client_response" - I assume this is a custom type of yours since I don't see it anywhere in the pgsql-http extension source code

from the looks of it, it seems that sticking the values from the response (status, content_type, etc) into your res variable fails and I think knowing the definition of http_client_response would help

other than this, I can suggest 2 other things:
 - you can introduce some logging into your functions (by logging, I mean writing to a dedicated logs table, because currently, you don't have access to the Postgres file logs)
 - this doesn't seem like a Supabase-specific issue but a more general PostgreSQL/PLpgSQL /pgsql-http so you might also want to ping the PostgreSQL community directly (https://www.postgresql.org/community/irc/)

<@!886735405884522526> 
```sql
    CREATE TYPE http_client_response AS
    (
        status       integer,
        content_type varchar,
        data         jsonb,
        type         integer
    );
```

are you sure you are getting the error inside the function and not in the caller of the function?

I tried to reproduce your error like this, but it works:

CREATE OR REPLACE FUNCTION public.test_http()
    RETURNS http_client_response AS
$$
DECLARE
    res     http_client_response;
BEGIN
    SELECT status, content_type, content::json->>'form' AS data, 5 from http_post('http://httpbin.org/post',
                 'myvar=myval&foo=bar',
                 'application/x-www-form-urlencoded') INTO res;

    RETURN res;
END;
$$ LANGUAGE plpgsql;

SELECT public.test_http();

It might be, I can get the code that calls it!

```sql
CREATE OR REPLACE FUNCTION public.events_dispatch_message(event_id uuid, dispatch_event_type event_type, message_id uuid, client bot_members)
    RETURNS VOID AS
$$
DECLARE
    message messages;
    res http_client_response;
BEGIN
    SELECT
        *
    INTO message
    FROM messages
    WHERE id = message_id;

    SELECT
           public.events_http_send_message_event(event_id, dispatch_event_type, client, message)
    INTO res;
END;
$$ LANGUAGE plpgsql;
```

all of the code is on https://github.com/github-chat/sql

`SELECT
           public.events_http_send_message_event(event_id, dispatch_event_type, client, message)
    INTO res;`

well, as I said, I don't really know PLpgSQL, but it seems that events_http_send_message_event() returns a string which you then try to stick inside a variable of type http_client_response

why events_http_send_message_event() returns a string instead of a record variable, I don't know

probably some subtlety related to PLpgSQL

You see, i change the line to just run it and ignore the returned data:
```sql
    EXECUTE public.events_http_send_message_event(event_id, dispatch_event_type, client, message);
```

and that still errors with: `syntax error at or near \"200\"`

yes, I see...not sure what the problem is, as I said, maybe you can ping the guys in the IRC postgresql channel

if you need to discard the result of events_http_send_message_event

the IRC channel are very helpful thx for the suggestion

if you do PERFORM public.events_http_send_message_event() instead of EXECUTE or SELECT it works fine

...but that discards the return value of the function call

<@!886735405884522526> you and the IRC channel has helped me fix it!

great - can you update us on what the issue was and how you fixed it?

so I just removed redudant function and as of this commit - https://github.com/github-chat/sql/commit/a4c6aa864d19e5261697ce3ab0756a27c6a11af4 - its working

ok, it looks like you replaced the SELECT ... INTO statement with a direct assignment :=...I am glad that it works now, but I don't really understand why one works and the other doesn't, which was the interesting part for me

as you have to reference a key to the forign key

you could do it in code after you get the values but im not sure thats what you want?

well i think i have to `.map` it in client

well thats okay but if there anyway to get that result directly would be awesome

btw is there anyway to create a custom method to supabase?

```js
  const { data, error } = await supabase
    .from("anime")
    .select(
      "title->userPreferred, recommendations!original_id(recommendations:recommend_id(*))"
    )
    .limit(1)
    .single()
    .map(); // Custom method


```

maybe this? https://supabase.io/docs/reference/javascript/rpc

yeah you write a postgres function then run it in the client

seems i have to learn it cuz i dont know it

Hi, I'm brand new on supabase, and I was wondering if there was any way to change the database password ?

https://supabase.io/docs/guides/database#resetting-your-project-password

God i'm so dumb, I just didn't see it... thanks !