Re: Missing FROM clause

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Ulrich Wisser" <ulrich(dot)wisser(at)relevanttraffic(dot)se>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Missing FROM clause
Date: 2004-08-25 08:11:58
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE475B1F@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Silvio Matthes 2004-08-25 08:23:20 Re: select ... where <column>='' does a seqscan [auf
Previous Message Michal Taborsky 2004-08-25 08:04:54 Re: Upgrading PostgreSQL 7.1.3