Ulrich Wisser wrote:
> 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: [277-1] LOG: query: SELECT *
> FROM LOGIN
> Aug 25 09:22:38 balder postgres: [277-2] where USERNAME='ulrich'
> Aug 25 09:22:47 balder postgres:  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
In response to
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|