Re: pg_dumpall and check constraints

At 11:33 1/07/00 +0200, Jan Wieck wrote:
>
>    Was late for me too, and maybe the answer was  too  lazy.  So
>    let me give you an example of what I meant:
>

About 5 mins after I hit the send button on my last message I realized the
error in my ways (again). There are probably limitations one could place on
such views, but the effort would be high, and the rewards low.

But, at the risk of yet another ill conceived plan being laid bare, and to
satisfy the original posters requirements, could FOREIGN KEY be extended to
allow:

    FOREIGN KEY({<field>|<literal>}...) references <table>({<field>}...)

This seems like a very convenient feature...if it's not too hard.



----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.C.N. 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   |/