Re: FK pointing to a VIEW
От | Lars Heidieker |
---|---|
Тема | Re: FK pointing to a VIEW |
Дата | |
Msg-id | 908997EE-AED2-40D6-B081-6B783333CCAC@merlin.de обсуждение исходный текст |
Ответ на | Re: FK pointing to a VIEW ("Olexandr Melnyk" <omelnyk@gmail.com>) |
Ответы |
Re: FK pointing to a VIEW
|
Список | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 10 Nov 2006, at 20:47, Olexandr Melnyk wrote: > > While I agree in principle that such a thing should be > > able to be done, it simply isn't possible. (in PostgreSQL, you can't > > even add an index to a view, which a unique constraint would depend > > on). > > Agreed on that. > > But such an extension would require a view to be more than just > SELECT. > > ------------------------------ > Olexandr Melnyk, > http://omelnyk.net/ > This would mean something like an index spreading over more then one table in the end, or did I miss something ? - -- Viele Grüße, Lars Heidieker lars@heidieker.de http://paradoxon.info - ------------------------------------ Mystische Erklärungen. Die mystischen Erklärungen gelten für tief; die Wahrheit ist, dass sie noch nicht einmal oberflächlich sind. -- Friedrich Nietzsche -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (Darwin) iD8DBQFFVRKiDAkIK9aNPuIRAgh9AJ97OrIyiaSCAn5lwxLtPFG6B7CtdQCfYyRf Aypj7GBygMNAxVEmYonkL3o= =hg/j -----END PGP SIGNATURE-----
В списке pgsql-general по дате отправления: