gnumed-devel
[Top][All Lists]
Advanced

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

[Gnumed-devel] gm-remove_person.sh problem ERROR: INSERT/DELETE on <clin


From: Jim Busser
Subject: [Gnumed-devel] gm-remove_person.sh problem ERROR: INSERT/DELETE on <clin_root_item> not allowed
Date: Fri, 08 Apr 2011 13:12:55 -0700

Does this script need to be root?

Does it need the user to log into the database and do the following which I 
cannot remember how, or the should the script do it?

        set default_transaction_read_only to off;

*******************************

MacBook:external-tools djb$ export PATH=$PATH:/Library/PostgreSQL/8.4/bin/
MacBook:external-tools djb$ sudo ./gm-remove_person.sh gnumed_v15 12

Creating removal script ...
    /tmp/gm-remove_person.sql

Are you sure you want to remove the person #12
*irrevocably* from the database "gnumed_v15" ?

Remove ? [yes / NO]:yes

Removing person #12 from database "gnumed_v15" ...
Password for user gm-dbo: 
ERROR: failed to remove person.
       see: gm-remove_person.log



**********************************

SET
BEGIN
psql:/tmp/gm-remove_person.sql:12: ERROR:  INSERT/DELETE on <clin_root_item> 
not allowed.

-- GNUmed person removal script

\set ON_ERROR_STOP 1
set default_transaction_read_only to off;

begin;

-- delete data
delete from clin.clin_root_item where fk_encounter in (
    select pk from clin.encounter where fk_patient = 12
);
--delete from clin.lab_request where fk_encounter in (
--    select pk from clin.encounter where fk_patient = 12
--);
--delete from clin.clin_hx_family where fk_encounter in (
--    select pk from clin.encounter where fk_patient = 12
--);

-- delete episodes
delete from clin.episode where fk_encounter in (
    select pk from clin.encounter where fk_patient = 12
);

-- delete encounters
delete from clin.encounter where fk_patient = 12;

-- delete names
delete from dem.names where id_identity = 12;




reply via email to

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