• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2271
  • Last Modified:

postgres ERROR: missing FROM-clause entry for table ""xxxxx""

I found the following message within syslog.

< message >
postgres ERROR:  missing FROM-clause entry for table ""xxxxx""

Note: ""xxxxx"" is masked.

I am not developer but manage server.
Would you please tell me the meaning and the solution?
1 Solution
Well I guess you are missing the From clause of your statement ... Propably you are using a SELECT or DELETE Statement ... in all you have to specify which table to select from:

SELECT * FROM table_users WHERE name = 'peter'
DELETE FROM talbe_users WHERE name='peter'
chunziAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now