Re: pg_dumpall and check constraints

Поиск
Список
Период
Сортировка
От Philip Warner
Тема Re: pg_dumpall and check constraints
Дата
Msg-id 3.0.5.32.20000702165946.00a42650@mail.rhyme.com.au
обсуждение исходный текст
Ответ на Re: pg_dumpall and check constraints  (JanWieck@t-online.de (Jan Wieck))
Ответы Re: pg_dumpall and check constraints  (JanWieck@t-online.de (Jan Wieck))
Список pgsql-general
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   |/

В списке pgsql-general по дате отправления:

Предыдущее
От: Philip Warner
Дата:
Сообщение: Re: Announce: Testers needed for revised pg_dump/pg_restore
Следующее
От: Marcin Inkielman
Дата:
Сообщение: vacuumdb problem