Postgre Node Removes Expressions

Questions
1

Hey n8n team!

When using the Postgres, when I hit refresh columns, all of the existing expressions entered in existing columns are wiped.

This mean everything has to be set up again when extending the database schema.

With other node, like Supabase, when refreshing, the existing expression remain intact.

Can we have similar behavior on the Postgres node?

Not sure if I should raise this as a bug or a feature request?

Thanks

:slight_smile:

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Hi @Wayne

Thanks for reporting this! We actually have this on our radar as it’s also been seen in Google Sheets and Airtable as well…

Also thanks for the Supabase clue, that will help in debugging this :wink:

https://linear.app/n8n/issue/NODE-2067/rmc-valuesexpressions-are-cleared-when-refreshing-columns-google

4

Hi @Wayne
this should be fixed now. Please let us know if you’re still encountering this bug. :pray:

5

@ria

I updated one instance of n8n and whilst this issue is fixed, a bunch of Postgres nodes are now failing, some on insert operations, on some numbers are now being rejected where they were not before.

Here is a log of one of the issue I’d found (sorry to be a pain!) Postgre Node Issuse After Update - Questions - n8n Community

6

Thanks @Wayne - let’s follow up in your new thread!