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 _______________________________________________ Gnumed-devel mailing list [email protected] http://lists.gnu.org/mailman/listinfo/gnumed-devel
