[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.

GPG key ID E4071346 @
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

reply via email to

[Prev in Thread] Current Thread [Next in Thread]