Solved

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

Posted on 2009-04-16
2
1,990 Views
Last Modified: 2012-05-06
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?
0
Comment
Question by:chunzi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 20

Accepted Solution

by:
ChristoferDutz earned 250 total points
ID: 24156625
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'
0
 

Author Closing Comment

by:chunzi
ID: 31570921
thanks
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Over the last ten+ years I have seen Linux configuration tools come and go. In the early days there was the tried-and-true, all-powerful linuxconf that many thought would remain the one and only Linux configuration tool until the end of times. Well,…
Little introduction about CP: CP is a command on linux that use to copy files and folder from one location to another location. Example usage of CP as follow: cp /myfoder /pathto/destination/folder/ cp abc.tar.gz /pathto/destination/folder/ab…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

736 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question