Re: [Gnumed-devel] gnumed demographic view

[Karsten Hilbert]

On Tue, Jul 04, 2006 at 07:07:08PM +0800, Syan Tan wrote:

> I originally had it in the demographic schema;
I know.

> iI put it in the public schema because the sql for mysql then
> works against the postgresql database.
I guessed as much.

> what might need to be done is to set the search schema path environment
> variable to include oscar,
Yes. Very much so. It might be doable by

"alter user set search_path", no ?

> are all the schemas on the search path already ?
No, explicit is better than implicit as an old Python adage
goes. But your situation does warrant putting "oscar" onto
the schema search path, yes.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346