Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2009-04-16
2
Medium Priority
?
2,166 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 750 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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

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…
The purpose of this article is to demonstrate how we can use conditional statements using Python.
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
Suggested Courses

618 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