Re: Missing FROM clause - Mailing list pgsql-general

From Magnus Hagander
Subject Re: Missing FROM clause
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE475B1F@algol.sollentuna.se
Whole thread Raw
In response to Missing FROM clause  (Ulrich Wisser <ulrich.wisser@relevanttraffic.se>)
List pgsql-general
> 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"

Check the PID field. Those messages are from different backends. 25538
which does the SELECT and 25590 which is something else.

//Magnus


pgsql-general by date:

Previous
From: Michal Taborsky
Date:
Subject: Re: Upgrading PostgreSQL 7.1.3
Next
From: Silvio Matthes
Date:
Subject: Re: select ... where ='' does a seqscan [auf