{message: 'invalid input syntax for type boolean: "3"', code: '22P02', details: null, hint: null} code: "22P02" details: null hint: null message: "invalid input syntax for type boolean: \"3\"" Can someone please give me some more details about this. I have 10 checkboxes in this form, and 10 boolean fields in the supabase table. Sometimes then I post a row from my next.js front-end this happens. Not everytime. Could it be that some column of boolean cant be false or true or what?

When you have a join table, you have to insert a row directly into the join table or into the parent table and it will insert the row automatically into the join table?

Not sure if this is a bug or intentional, why does the

postgres

user not have read access to the

graphql._type

table? This would for example prevent a user from dumping the entire database. Should users not dump that schema? Also, the weird bit is that only one of my several databases have the

graphql

and

graphql_public

schemas. The tables in these schemas are populated too. I'm pretty sure I did not enable any GraphQL related features in that database. Also, I'm aware I could just give the role access to that table, just wondering how GraphQL got into my database, and why a superuser role doesn't have access to it

I am installing supabase from scratch on kubernetes with an external postgres cluster db, but an error running db migrations from scratch at Auth Service (supabase/gotrue) all other containers seems to be running smooth except Realtime Service (supabase/realtime) that still waiting for migration table creation supabase-auth logs

Sun, Jul 31 2022 1:46:26 am | [POP] 2022/07/31 07:46:26 info - 0.0582 seconds
Sun, Jul 31 2022 1:46:26 am | time="2022-07-31T07:46:26Z" level=fatal msg="running db migrations: Migrator: problem creating schema migrations: CREATE TABLE \"schema_migrations\" (\n\"version\" VARCHAR (14) NOT NULL\n);\nCREATE UNIQUE INDEX \"schema_migrations_version_idx\" ON \"schema_migrations\" (version);: ERROR: no schema has been selected to create in (SQLSTATE 3F000)"

Any suggestion?

Is there a way to add custom metadata (like a computed hash value) to a file while uploading it, so it is appended to the metadata column in storage.objects?

Hello, is there any DNS/network issues today with supabase?

I've noticed that my apps are not being notified when the database changes from another machine. I've got replication setup

Hello @krum! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

I've created a publication on my database, but am having trouble creating the subscription on a replica, following this example: https://github.com/burggraf/postgresql_replicas

Does supabase cast

3.0

to

3

in a

float8

field?

are Edge Functions going into feature freeze today or during launchweek? in the docs, its says "experimental until 1 August 2022"

Hello @dayvista! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

Hi, we thought to use Supbase for authentication only with an Elixir Backend We are fine with free plan limit 50K MAUs my question is, in the pricing page it says > Free projects are paused after 1 week of inactivity. Does this applies to authentication also?

Hi guys, I am having this error on my first webpage load

I don't understand why am I getting the error 'unexpected end of json input' ? This is an edge function

Hi, how to reload schema cache? My error was could not find a relationship between x and y tables in schema cache.

Does anyone have any tips for how to handle a staging database using Supabase? Id like to have a staging Supabase account setup that can be used in CI to test out new features before migrating those changes to production. The biggest thing Im trying to come up with is a migration strategy for resetting the staging database for a given feature branch. Here's what I've come up with so far and any help poking holes in it or advice is greatly appreciated! On push of [main] - Github workflow setup to run tests on push that run against a local Supabase instance via Docker (works fine) On publish of [main] - Github workflow to merge pending migrations to the production Supabase account (works fine) **On push of [staging] *HELP!* - Github workflow to merge all migrations in schema to a Supabase staging account - On the next push, take the state of that schema and treat it as a brand new migration. Otherwise I need to push a migration to take down the previous migration, and then repeat the process. - Im basically looking for the capabilities I have with

supabase db reset

but with an actual Supabase account, not just a local database. I'd love to hear how any of you have handled a staging environment for your apps!

The docs on generating types (https://supabase.com/docs/reference/javascript/generating-types) mention a soon to come in-house type generation solution. Is there some gh issue/discussion on this matter somewhere? From my understanding the current openapi-typescript alternative doesn't generate return types for functions

.rpc(...)

, is this feasible in a different way (without defining types manually)?

I got some big json columns (mb) which make viewing the table editor slooooow on supabase site😅 any settings to not load the entire json column content? 🤔

Also, completely unrelated, but is it possible to use supabase functions, just ... Not on the edge, and just having them as physically close to the DB as possible, if i need to make multiple requests to the DB, that can't be put in postgres functions or compressed in a single query

If I work with real time data from the postgres supabase database in next.js. And I have one table synced (See code). What If I wanna work with data from another table as well in the same component. How do I structure that call to supabase?

const [result, reexecute] = useRealtime('housingrequests');
  const { data: housingrequests, error, fetching } = result;

Hey I have a question. How have people managed multiple environments (Dev, Staging, Prod) in Supabase? Right now I have two separate projects (Dev, Staging) but I want to be able to "version" everything. Has anyone done anything like this?

Is there something wrong with this? request.city is 'Uppsala' and one column in the table hosts is called city, where there are rows with the value 'Uppsala'. Seems I'm getting the host value undefined, but no errors.

const { data: hosts, error, fetching } = supabase.from('hosts').select('*').eq('city', request.city);

Hello, how can I add a new , user if I don't have an app url? The user I invite gets an email to a blank localhost:3000 address basically.

Hello, I tried to reset my password for my database and now I can't even reach the host

psql -h db.tizfyfxzgjewdjshnhan.supabase.co -p 5432 -d postgres -U postgres

Here is the error with psql you can try, this is a dev database.

psql: error: connection to server at "db.tizfyfxzgjewdjshnhan.supabase.co" (18.197.17.237), port 5432 failed: Connection refused
        Is the server running on that host and accepting TCP/IP connections?

ts
import { createContext, useContext, useEffect, useState } from "react";
import supabase from "../../utils/supabase";

const user = supabase.auth.user()

const Context = createContext(null)
export const UserInfos = ({children}:{ children: React.ReactNode }) => {
    const [data, setData] = useState()
    useEffect(() => {
        async function loadProfile() {
            const { data } = await supabase.from('profiles').select('*').eq('id', user?.id).single()
            setData(data)
        }
    }, [])

    return(
        <Context.Provider value={{data}}>
            {children}
        </Context.Provider>
    )
}

export const useUserInfos = () => useContext(Context)`

trying to fetch but it always undefined, it is something i did wrong ?

How can I use the supabase client in my edge function? do I need to import supabase from deno?

I'm trying to batch upload about 1,230 records using prisma during my db seeding, but I keep getting the following error:

Error: Command was killed with SIGSEGV (Segmentation fault): node --require esbuild-register prisma/seed.ts

if I connect to a local postgres db, it works fine. Any ideas?

Hey Folks, I have a general architecture question. I'm building MFA support into an external api. Right now the api is authenticated using Supabase auth tokens. What I'm trying to achieve is force the user to enter an mfa code (secret encrypted in supabase) when they login and have that mfa validation last for the duration of the session. From what I understand a session will last 1 hr (depending on auth settings) and can be extended using the refresh token. There's no session id to check against so I can't see how I might store the mfa verification. Thoughts on this are: 1. I can't use app_metadata because that's available to every token when logged in 2. I can't use user_metadata because that's user-accessible and available to every token 3. I can't encode a jwt token representing authentication because (1) it wouldn't be sent with every supabase-js request and (2) it wouldn't be able to be tied to the authentication session (so moving the token to a different device with the same user would yield access).

How is it possible to make join queries against 2 tables that have matching columns? Do I actually have to create foreign key relationships?