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 17:04:48 -0700

Or maybe not success... ?? See screenshot. Despite running the now- obsoleted script

        v11-drop_obsolete_groups-dynamic.sql

which I saved locally as

        drop_demo_pts.sql
        
the patients appear to remain there. Does "deleting" in postgres only set flags in the affected rows, and is some further action required (such as in old dBASE to "pack" the database) before the record is truly gone? Or might there be a bug?

On 8-Aug-09, at 4:51 PM, Jim Busser wrote:

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#

PNG image


reply via email to

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