Re: CONSTRAINT ... FOREIGN KEY

From: <operationsengineer1(at)yahoo(dot)com>
To: "tvis" <tovises(at)freemail(dot)hu>, pgsql novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: CONSTRAINT ... FOREIGN KEY
Date: 2005-05-03 02:30:09
Message-ID: 20050503023009.36421.qmail@web52408.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

--- tvis <tovises(at)freemail(dot)hu> wrote:
> Creating/adding a "FOREIGN KEY" creates any "real"
> key sequencies?

tovis, i'm not sure of the technical details, but a
link is created between the foreign key and the column
it references.

> Foreign key constraint became a key - seem to me,
> but what about the foreign table, there is also
> created a "seemless" key or I should create somthing
> (of course if it is not the primery key) - index?
> Sincerelly
> tovis

the foreign key should most definitely reference
another column in another table.

your question is a little hard for me to understand -
i hope i answered it.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2005-05-03 02:31:19 Re: Purpose of pgsql/data/global directory? - permissions error
Previous Message operationsengineer1 2005-05-03 02:24:28 Re: Foreign Key Problem