hi team i'm having issues with inserting data into...
# help
l
hi team i'm having issues with inserting data into a table.. i'm getting 201 without errors on the frontend. i've also tried to add manual entries via the UI without any success (attached a video)
n
Hello @lanbau! 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.
l
weird bug encountered.. empty rows added when i close the panel
g
201 is not an error, it is good insert on the front end. The dashboard just had major lockout. Just in case, do full refresh on dashboard page.
n
lanbau (2022-05-24)
l
yes i've cleared the cookies and did a hard reset
still unable to insert rows
g
It is odd because the 201 response says it succeeded...
l
thats on the frontend
but on the dashboard, i can't do a manual insert
i get empty rows
g
Or you can't see the results, your second video is very strange as you are hitting cancel...
Do you have any triggers on this table?
l
holy you are right. i created a trigger a few days ago
any idea how we can see the triggers we have created 😅
g
I use the dashboard for a quick check under database triggers.
I normally use Datagrip though instead of the UI as it is part of my IDE. Once you start getting into triggers and data types not in the UI you need to consider a database tool, at a minimum PGADMIN. There are many and connect directly thru the Postgres user port.
https://database.dev/ is also a good resource for admin sql code to run in the sql window (including showing triggers)
l
cool which ide are you using?