Got couple of questions: 1.) Is it possible to con...
# help
a
Got couple of questions: 1.) Is it possible to connect to local instance with pgAdmin? When I enter my localhost:54322/postgres as host I get error. 2.) Anyone had issue with delete on cascade actually not deleting referenced items? 3.) What is the proper way to seed online instance? If I try to do it over API I get request exceeded error.
n
Hello @avalanche! 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.
c
1) I don't use a local instance so I might be wrong here, but maybe you have a type in the port - PostgreSQL port convention is 5432, not 54322 2) Never seen this, but I don't see how this can be a Supabase issue and NOT a PostgreSQL issue (which would be a very serious bug, so it seems more likely that the issue is with your SQL definitions) 3) You can connect to the online instance directly via any SQL console/workbench (e.g. psql, TablePlus, Supabase dashboard, etc) and execute the seeding statements from there. DB migration tools such as FlyWay also allow you to define migrations that seed the db and they also connect directly to the db (i.e. they bypass the REST APIs)
n
avalanche (2022-05-18)
a
1.) fixed, local instance spits out localhost:54322/postgres as link to DB. After removing /postgres I was able to connect. 2.) fixed, error was in trigger defined on table which was supposed to delete cascade. Thanks!