gnumed-devel
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] removing test data


From: Jim Busser
Subject: Re: [Gnumed-devel] removing test data
Date: Sat, 08 Aug 2009 16:51:33 -0700

On 8-Aug-09, at 2:17 AM, Sebastian Hilbert wrote:

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.


gnumed_v11 not template1


Oops! Success using psql -h localhost gnumed_v11 -U gm-dbo -f <scriptname>

debian:/home/jbusser/v11.rc5/server/bootstrap# psql -h localhost gnumed_v11 -U gm-dbo -f drop_demo_pts.sql
Password for user gm-dbo: 
SET
BEGIN
psql:drop_demo_pts.sql:25: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "persons_to_delete_pk_identity_key" for table "persons_to_delete"
CREATE TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
DELETE 1
DELETE 1
DELETE 1
DELETE 2
DROP RULE
DELETE 2
CREATE RULE
COMMIT
       log_script_insertion       
----------------------------------
 03042ae24f3f92877d986fb0a6184d76
(1 row)

debian:/home/jbusser/v11.rc5/server/bootstrap#

reply via email to

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