Re: [Fwd: Schema Question]

On Thu, Mar 02, 2006 at 03:45:01PM -0500, Oisin Glynn wrote:
> I have a seperate schema with a function and table. The function does a
> select on the table.
> The table and function exist in public schema and betteridea schema. I
> have a user betteridea who owns the betteridea schema.
<snip>
> If I connect as postgres user and do select * from
> betteridea.zfunc_get_employee('1234');
> or
> select * from zfunc_get_employee('1234');
>
> with no schema in front of it.
> It is returning the data from the public.employee_list in both cases!

Take a look at searh_path in the manual.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461