N8N uptodate (Docker, Qnap, self hosted) - Problem with postgresql node (data ingestion)

Questions
1

Problem with Postgresql node and data ingestion

Error message

image
image700×220 23.1 KB

Hi all I’m trying to populate a table with the postrgesql node. The has been created successfully, and I have a specific column named geom which a geometry column to store a point for mapping;
When I use this query in pgadmin evrything works : INSERT INTO acledgat (geom) VALUES (ST_GeomFromText(‘POINT(12.5 40.2)’));

But when I want to do the same with the postgresql node I have an error (incoming data are stored into a json file)

image
image1566×1802 241 KB

If someone had an idea … Thx

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
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

Problem solved by adding an another step in which I make a query to “build” the geom with the columns longitude and latitude.

1 Like