[Top][All Lists]
[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;
- [Gnumed-devel] gm-remove_person.sh problem ERROR: INSERT/DELETE on <clin_root_item> not allowed,
Jim Busser <=