Re: [Gnumed-devel] Some suggestions to make gnumed more efficient

[Karsten Hilbert]

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