> Within PostgreSQL, two objects can have the same name if they are of > different types (note, relations is a fairly broad type category) or they > exist in different schemas.
The Oracle case probably also works by putting the tables in different schemas. I recall hearing that Oracle identifies "owner" with "schema" much more closely than we do.