Ulrich Wisser wrote:
> Hi,
> 
> after seeing some mysterious messages about missing from clauses I did 
> turn on query logging. Unfortunately am I now more confused then before.
> 
> 
> Aug 25 09:22:38 balder postgres[25538]: [277-1] LOG:  query: SELECT * 
> FROM LOGIN
> Aug 25 09:22:38 balder postgres[25538]: [277-2] where USERNAME='ulrich'
> Aug 25 09:22:47 balder postgres[25590]: [277] NOTICE:  Adding missing 
> FROM-clause entry for table "partner"
> 
> Please find the definition of my login table below.
> 
> Why would pg add the partner table to the query?

The only things I can think are:
1. You have a view named "login" which is earlier in your search path.
2. The query is not terminated in some way and you have two queries 
being merged.

-- 
   Richard Huxton
   Archonet Ltd

In response to

• Missing FROM clause at 2004-08-25 07:58:53 from Ulrich Wisser

pgsql-general by date

Next:	From: Gaetano Mendola	Date: 2004-08-25 09:15:03
	Subject: Re: Problem to connect to the Windows Port
Previous:	From: Silvio Matthes	Date: 2004-08-25 08:23:20
	Subject: Re: select ... where <column>='' does a seqscan [auf