Re: [Gnumed-devel] removing test data

[Karsten Hilbert]

On Fri, Aug 07, 2009 at 11:41:06PM -0700, Jim Busser wrote:

> >I have added the following script which will enable people
> >to delete most test data on a stock v11 database.
> 
> I saved the script as
> 
>       drop_demo_pts.sql
> 
> but when I tried to run it as postgres user gm-dbo I was denied and
> instead was advised "permission denied to create temporary tables in
> database "template1"".

You need to run it against the database you want to drop
patients from.

> postgres=# alter role postgres with password '123';

Don't do that. It will prevent Debian from doing database
maintenance.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346