does anyone know how to find out whether a row is currently referenced by a row in a different table? They are bound together by a foreign key constraint.
The reason why I would like to know this is that I would like to be able to delete rows only if they aren't used anywhere. If this can't be done by a single query, does anyone have such a function they could share or at least a few hints where I could look for more information?
It occurred to me that I could create a function that would query a system table for all references to the table the row would be deleted from and then scan tables that refer to that one, but I was hoping there would be a simpler and maybe a more efficient way to do this.
Thanks in advance.
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2010-07-01 15:07:10|
|Subject: Re: How to find out whether a row is currently referenced by a row in a different table? |
|Previous:||From: Thom Brown||Date: 2010-07-01 08:31:10|
|Subject: Re: null vs empty string|