Hallo Christoph, > I loaded the gm-schema-dump.sql with Emacs and replaced 95 > character varying with varchar. The explanation is, that if you use > varchar and dump the db, pg_dump writes character varying, no matter > wether you have used character varying oder varchar. Aha, that makes sense ! :-)
Will try to convert all the remaining varchars over time. > Importing the gnumed schema with psql into my database now works perfect. Nice. > The solution: > I connected via pgAdminIII to gnumed db on saalam.homeunix.com, copied the > users and groups, loaded them into my PostgreSQL db, and then I replaced > gnumeds orignal CREATE FUNCTION plpgsql_call_handler()... > with > CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler > AS '$libdir/plpgsql', 'plpgsql_call_handler' > LANGUAGE c; I have added that option to our bootstrapper already. 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
