From: dori!wiz@uunet.uu.net (Karl Schendel)

On Apr 16, 22:29, jeff kennedy wrote:
> Subject: Duplicates in iitables...
>   i noticed some duplicate table definitions
>   held on the view iitables (i.e., more than
>   one iitables row with the same table_name,
>   but all with different table_owners), and
>   wondered if this was 'normal' or not ....

Yes, perfectly normal, and it simply implies that various users
have their own (private) tables that happen to be named the same.

If a user drops their private table, and there is a table with
the same name owned by the database's DBA, that user will start seeing
the DBA table.  If a user drops a private table and there is no table
with the same name owned by the DBA, that table appears to be nonexistent
to that user.  (even if other non-DBA users have tables with that name).
There are some subtleties involving REPEATED queries and multiple table
copies that I won't go into, but in general it does what you (well, what
I) would expect.

I have some notion that the table ownership business was expanded in
OpenIngres, but I don't recall the details -- that wasn't one of the
OI manual sections I spent much time looking at.

-- 
Karl Schendel            Phone: (412) 963-8844
Telesis Computer Corp      Fax: (412) 963-1373
wiz@telesis.com

Ingres Q & A

To William's Home Page

© William Yuan 2000

Email William