Insert: ERROR [0A000] ERROR: cross-database references are not implemented

[julio.magaia]

Hi,

I have a postgresql database table named “testIncomplete”, and I have a data table named Dt. The connection is tested and its connects when I try and read from the table I get the output but when I run the Insert

I get the error:
Insert: ERROR [0A000] ERROR: cross-database references are not implemented: “UiPath.public.testincomplete”;
Error while executing the query

[Shiva_Nikhil]

@julio.magaia

check the below

Insert data into postgre DB

Hello @1223851533! It seems that you have trouble getting an answer to your question in the first 24 hours. Let us give you a few hints and helpful links. First, make sure you browsed through our Forum FAQ Beginner’s Guide. It will teach you what should be included in your topic. You can check out some of our resources directly, see below: Always search first. It is the best way to quickly find your answer. Check out the [image] icon for that. Clicking the options button will let you set…

cheers

[Parvathy (PS Parvathy)]

Hi @julio.magaia

The error message you’re encountering, “cross-database references are not implemented,” suggests that you are trying to reference a table from a different database within your SQL query. In this case, it seems you might be trying to reference the “testincomplete” table from a different database called “UiPath” which is not allowed in PostgreSQL.

Make sure that you are connected to the correct database (the one where the “testincomplete” table resides) when you’re executing the INSERT query. Double-check your connection settings and ensure that you are not accidentally referencing a table in a different database.

Hope it helps!!

[julio.magaia]

Hi @Shiva_Nikhil
It is not a solution

[julio.magaia]

Hi @Parvathy,
I am connected to the right database, when I run a select query it does return the table.

[Shiva_Nikhil]

@julio.magaia

can you check it with UiPath support Team

cheers