From: | Philip Warner <pjw(at)rhyme(dot)com(dot)au> |
---|---|
To: | Rod Taylor <rbt(at)rbt(dot)ca> |
Cc: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: pg_dump in 7.4 |
Date: | 2002-11-13 14:52:34 |
Message-ID: | 5.1.0.14.0.20021114013709.02c595c0@mail.rhyme.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
At 09:29 AM 13/11/2002 -0500, Rod Taylor wrote:
>An ALAP scheduling algorithm will almost always sort these things to be
>side by side to allow combining on a second pass by something with the
>intelligence.
Do we have a list of dependency data that we collect? eg. do we know about
functions used in views and indexes? At this stage it's probably worth
making a list of what we think is achievable in 7.4, and what we want to
achieve ultimately. I certainly agree about recombining function headers
and bodies, but there are a bunch of things that I think we can leave
deconstructed and always move to the end of the restore, eg:
- constraints
- sequences set (not really a dependency problem)
- indexes
- comments
AFAIR, we can only split function bodies for non-SQL functions.
For views we need to know the types of casts within the view, the types
returned by the view, the functions used by the view as well as the tables
referenced. AFAIR, there is no way to break up a view, so it has to go
after each ancestor.
For a table, it should be sufficient to know the constraints & types; we
can add constraints later, but I'd be reluctant to get into doing 'ALTER
TABLE ADD COLUMN...'.
Indexes may have a function and/or a cast? Create Index I on T( cast(id as
my_type) )?
I'd guess constraints can depend on multiple tables, views(?), types, &
functions. Not sure what else. We can't really break these down.
So it looks like the only contentious item might be table attrs? is that right?
----------------------------------------------------------------
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 |/
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-11-13 15:06:15 | Re: RC1? |
Previous Message | Tom Lane | 2002-11-13 14:43:46 | Re: null values / partial indices |