Does anyone know if it's possible to disable data integrity check when doing a select for the whole object graph - using queries like "FROM Sometable t"?

i ran into a problem when one of the records has a reference (via a foreign key) to another object, and the other object does not exist since the record in the database has been deleted, i.e. the database is not enforcing foreign key constrains and has orphaned records.

What i want is to still have a result set, but with that faulty record left out, rather than let the whole query fail completely.

i'm using Hibernate 2 and PostgreSQL.

Thanks!