Solved

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

Posted on 2009-04-16
2
1,872 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
2 Comments
 
LVL 20

Accepted Solution

by:
ChristoferDutz earned 250 total points
Comment Utility
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
Comment Utility
thanks
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduction We as admins face situation where we need to redirect websites to another. This may be required as a part of an upgrade keeping the old URL but website should be served from new URL. This document would brief you on different ways ca…
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
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…
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.:

771 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now