Solved

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

Posted on 2009-04-16
2
1,971 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Many developers have database experience, but are new to PostgreSQL. It has some truly inspiring capabilities. I have several years' experience with Microsoft's SQL Server. When I began working with MySQL, I wanted a quick-reference to MySQL (htt…
Google Drive is extremely cheap offsite storage, and it's even possible to get extra storage for free for two years.  You can use the free account 15GB, and if you have an Android device..when you install Google Drive for the first time it will give…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

756 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