Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group