Re: setting up foreign keys

On 8/10/06, Chris <dmagick@gmail.com> wrote:
> Sue Fitt wrote:
> > Thanks Chris and Chris, you've solved it.
> >
> > I had a gui open that connects to the database. It was doing nothing
> > (and not preventing me adding to or altering headwords_core via psql),
> > but having closed it the table is instantly created. Weird.
> >
> > BTW, referencing the same column twice is deliberate, it's a
> > cross-reference.
>
> The same column and the same table?
>
> Same column different table I could understand but not the same column &
> table ;)

create table color(color text);

create table person(eye_color text references color(color), hair_color
text references color(color));

;)
merlin