Joaquin,
The foreign key is from users.person_id to person.person_id.
So you need to do
delete from person where person_id not in (select person_id from users);
-Darius
On Mon, Dec 19, 2011 at 1:19 PM, Joaquín Blaya <
[email protected]> wrote:
> I'm trying to delete all patients from an OPenMRS instance and I've
> deleted everything but the persons table. However, when I try this
>
> delete from person where person_id not in (select user_id from users);
>
> I get the following
> ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key
> constraint fails (`openmrs/users`, CONSTRAINT `person_id_for_user` FOREIGN
> KEY (`person_id`) REFERENCES `person` (`person_id`))
>
> How can this be if I specifically tell it not to include anyone in the
> users table? What should I be using to delete all persons not included in
> users?
>
> Thanks,
>
>
> Joaquín
> ___________________________________________________________________
> Gerente de Desarrollo, eHealth Systems <http://www.ehs.cl/>
> Research Fellow, Escuela de Medicina de Harvard <http://hms.harvard.edu/>
> Moderador, GHDOnline.org <http://www.ghdonline.org/>
> ------------------------------
> Click here to
> unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from
> OpenMRS Implementers' mailing list
_________________________________________
To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to
[email protected] with "SIGNOFF openmrs-implement-l" in the body
(not the subject) of your e-mail.
[mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l]
