That is an interesting one it looks like there could be a couple of issues. Is the postgres instance your instance or is it managed by a Supabase install?
Can you try removing the expressions for now and see if that gets you any closer? I have just given it a quick go with a supabase cloud account and I am able to use the Insert / Update operation.
I had the first part of that issue with the list not loading until I went into the credential but for me I was able to select the value to update.
I have just made a smaller test though and that did result in the same error message coming back, Looking at your example workflow you are using the upsert but you only have the uuid going into the node. If you add more data so it has what it needs to insert in the set node does that work?
That is very odd as that is what is currently working for me on a couple of different instances. Can you share the schema or create a test table and try with that?
The issue also appears on my table but only if I only have one field coming in, I want to make sure I fully understand what the issue actually is and how to reproduce it.
If you are seeing it with multiple input fields then there must be more to it, I need to write up a ticket for the other UI issue although that doesn’t appear to impact the query itself.
In your test if you add say the name field in the set node as well are you sure that it doesn’t work?
Could you also try with the Execute Query option as well and see if that works, We do have at least 2 bugs here that we will need to fix so at the moment I just want to make sure that we can at least get you working. The other option would be to try the supabase node and see if that works for you.
The error on the side does’t matter as much the good news here is the actual writing of data does work when used as expected which is fine.
So we just need to work out how to handle just one value which seems unlikely to happen but could happen and to work out what is going on with the UI loading.
To work around the UI issue what I did was open and close the credential then in the column to match on field click on the 3 dots and select refresh list.
Can you try using execute query instead and seeing if that works, It sounds like maybe there is an intermittent connection error as well.
Could you also try copying one of the other nodes and seeing if that works, there are 3 versions of the Postgres node so there could be something wrong with 2.1 and the other nodes might be using v2 or v1.