At 18:29 14/04/01 +1000, Philip Warner wrote:
>
>I don't suppose we can change the pg_views view without an initdb?
>
Having now looked at the source, I realize that initdb is where this view
is defined. However, is there any reason that we can not change this
definition when upgrading to 7.1.1?
The embargo on initdb is, I think, primarily related to avoiding
export/import of databases - is that right? If so, then doing
non-destructive changes to things like system views does not seem too evil
(in this case an update of a row of pg_rewrite and the addition of an attr
to pg_views, I think).
Am I missing something here? ISTM that the more higher level definitions we
have (eg. functions returning multiple rows, DEFINITION SCHEMAs etc), the
more we may need to allow changes to be made of things that are
*customarily* defined in initdb.
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \| | --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/