Re: how to know this row has been referenced or not????

On Thu, Feb 10, 2005 at 07:00:14PM +0700, Akbar wrote:

> How do I know for sure that "this row" or "that row" has or has not
> been referenced by other table????

Why do you need to know?  What are you trying to do?

> Of cource I can test it by trying to delete it.... if it has
> been referenced, the delete command will fail, and if it has not been
> referenced the delete command will success.....

If the referencing table uses ON DELETE CASCADE then the delete
will succeed and it'll also delete the rows in the other table.

Even if you do find out that nobody's referencing the row, the
situation could change immediately after the check unless you take
steps to prevent that from happening (e.g., through locking).

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/