At 01:50 PM 13/11/2002 +0800, Christopher Kings-Lynne wrote:
>Well, the problem is that you can add a new type and then add a column to a
>really old table that uses that type - that causes pain\
You may have misunderstood; I meant to add each type used by the table to
the deps list for a table (and each function used by a view etc etc).
Current implementation leaves the deps list blank for tables, and only
lists the tables for a view (I think).
The problem with the current deps list is that (a) it assumes that OID
order is important and (b) it does not do any analysis of the topology of
the dependencies.
The latter will be substantially improved if we can get pg_depend deps into
the dump file, and if we can do a useful analysis of the dependencies.
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 03 5330 3172 | ___________ |
Http://www.rhyme.com.au | / \| | --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/