At 01:50 PM 13/11/2002 +0800, Christopher Kings-Lynne wrote:
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).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\
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 |/
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
