[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] gnumed demographic view
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] gnumed demographic view |
Date: |
Tue, 4 Jul 2006 13:17:37 +0200 |
User-agent: |
Mutt/1.5.11+cvs20060403 |
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