ERROR [42P01] Workbench

Reply
Highlighted
White Belt

ERROR [42P01] Workbench

Hi All,

 

One of my dataset got into error and I would like to know the cause of it and how to resolve it. Below is the screenshot of the error in workbench. 

The error is -  ERROR [42P01] ERROR: relation "company_setting" does not exist; Error while executing the query

sadsaf.png

Thank you,


Accepted Solutions
Major Brown Belt

Re: ERROR [42P01] Workbench

This appears to be on the DataBase side. It sounds like relationships don't exist on the DataBase. 

You will want to speak with your DataBase Administrator in this case. They will be able to investigate what is causing this behavior. 

 


All Replies
Green Belt

Re: ERROR [42P01] Workbench

Are you querying a SQL table or a SQL view?

White Belt

Re: ERROR [42P01] Workbench

SQL Table

Green Belt

Re: ERROR [42P01] Workbench

Ok thanks. And what kind of database are you trying to query?

 

At first glance, this looks like a PostgreSQL error, and specifically something structural with the table itself.

 

Can you query the table successfully in a local query environment? 

Major Brown Belt

Re: ERROR [42P01] Workbench

This appears to be on the DataBase side. It sounds like relationships don't exist on the DataBase. 

You will want to speak with your DataBase Administrator in this case. They will be able to investigate what is causing this behavior. 

 

Announcements
Looking for the latest Community solutions? Please visit our accepted solutions board here!