Forum OpenACS Development: Re: Problem when i tried to delete a user from db (nuke user)
5: Re: Problem when i tried to delete a user from db (nuke user) (response to 1)
Posted by Enrique Catalan on 11/11/04 04:52 AM
Yes, that is a better way. but in that way we have to modify the constraints on some tables, adding the "on delete cascade" option.
I found other one (a little more complicated but it should works); it is to use the pg_constraint, pg_class and some other system tables of the pg_catalog to find all the columns of all the tables that has a contype='f' (constraint type is foreign key), using the 'conrelid' and 'confrelid' (http://www.signal42.com/pgsql/catalog-pg-constraint.html) fields to get the rows that i have to delete.
what do you think about it ?