View & search_path

[datactrl]

postgresql 8.3
Views do not follow search_path. It always uses the tables in the same schema of itself.

CREATE OR REPLACE VIEW public.admv_acct AS 
 SELECT a.itemno, a.itemtype, a.category, a.itemdesc, a.negativeacct
   FROM adm_items a
  WHERE a.itemtype::text = 'A'::text
  ORDER BY a.itemno;

The adm_items in public is always used.

[rski]

Could you post here your search_path set?