On Tue, Nov 28, 2006 at 03:33:54PM +0200, Olexandr Melnyk wrote:
> >This would mean something like an index spreading over more then one
> >table in the end, or did I miss something ?
>
> Yes. But that is hardly implementable.
Actually, an index over multiple tables is not really the hard part.
I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 28 Nov 2006, at 13:33, Olexandr Melnyk wrote:
Looks like I've missed your mail, so a late reply.
2006/11/11, Lars Heidieker <[EMAIL PROTECTED]>:
> > > While I agree in principle that such a thing should be
> > > able to be done, it simply isn
Looks like I've missed your mail, so a late reply.
2006/11/11, Lars Heidieker <[EMAIL PROTECTED]>:
> > 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 wo
-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
>
> 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.-
Sandro Dentella <[EMAIL PROTECTED]> schrieb:
> Do I understad correctly that i cannot point a Foreign Key to a view? Which
> is the rationale of this?
A VIEW is simply a regular SELECT ..., a string that contains a SELECT.
Question: How can you add a FK to a string? You can add a FK to a table,
On 11/10/06, Sandro Dentella <[EMAIL PROTECTED]> wrote:
Do I understad correctly that i cannot point a Foreign Key to a view? Which
is the rationale of this?
Blame the sql standard. Foreign keys are required to reference a
table with a unique constraint, and you can't add a unique constraint
t
Do I understad correctly that i cannot point a Foreign Key to a view? Which
is the rationale of this?
TIA
sandro
*:-)
test=# alter table mail_inviate
test-#add constraint mail_inviate_fk
test-#FOREIGN KEY (mittente) REFERENCES mail_view(mail_address)
test-# ;
ERROR: referenced relation
