Missing FROM clause

[Ulrich Wisser]

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='ulric h'
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?

TIA

Ulrich



DB1=> \d login
Table "public.log in"
Column | Type | Modifiers
---------------+-------------------------+-------------------------------------------
loginid | integer | not null default
nextval('s_logi n'::text)
username | character varying(64) | not null
password | character varying(16) | not null
email | character varying(128) | not null
accesslevelid | integer | not null
partnerid | integer |
resellerid | integer |
customerid | integer |
roles | character varying(1024) |
realname | character varying(64) | not null
Indexes: login_p01 primary key btree (loginid),
login_u01 unique btree (username)
Foreign Key constraints: login_f01 FOREIGN KEY (accesslevelid)
REFERENCES accesslevel(acc esslevelid) ON UPDATE CASCADE ON DELETE RESTRICT,
login_f02 FOREIGN KEY (partnerid) REFERENCES
partner(partner id) ON UPDATE CASCADE ON DELETE RESTRICT,
login_f03 FOREIGN KEY (resellerid) REFERENCES
reseller(resell erid) ON UPDATE CASCADE ON DELETE RESTRICT,
login_f04 FOREIGN KEY (customerid) REFERENCES
customer(custom erid) ON UPDATE CASCADE ON DELETE RESTRICT


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Richard Huxton]

Re: Missing FROM clause

Ulrich Wisser wrote:[color=blue]
> 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='ulric h'
> 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?[/color]

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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings