automatic detection of nomore references rows

Hi all,

here's my question of the day:

Since 7.3 now has some more intelligent FOREIGN KEYs (i.e. pg_dump still
knows that certain triggers serve as foreign keys)
is it possible to detect unreferenced rows ?

e.g.:

upload
--------------------
id_upload | filename

picture
--------------------
id_upload | orientation

attachement
--------------------
id_upload | name

Of course I could detect unreferenced rows myself with NOT EXISTS etc.
but as I have many tables that reference upload it would be more
convenient to

SELECT id_upload FROM upload WHERE id_upload IS UNREFERENCED

or something like that.

bye
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : www.e-trolley.de