Foreign keys?

From: "Dr(dot) Evil" <drevil(at)sidereal(dot)kz>
To: pgsql-general(at)postgresql(dot)org
Subject: Foreign keys?
Date: 2001-07-13 00:35:00
Message-ID: 20010713003500.12027.qmail@sidereal.kz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


There doesn't seem to be much documentation on foreign keys and how to
use them properly.

I am setting up a DB with two tables: users, and a table of objects
where are always owned by users. I want to make sure that there's no
way to have an object which isn't owned. Let's say these are the
tables:

CREATE TABLE user (
number INT4,
name VARCHAR(400)
);

and

CREATE TABLE object (
owner INT4,
description VARCHAR(200)
);

The constraint is that there should never be a row in the object table
where the owner column has a number which doesn't have a corresponding
owner in the user table.

I'm sure I can do something with foreign keys to implement this
constraint, but I can't figure it out.

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jason Earl 2001-07-13 01:17:41 Re: Foreign keys?
Previous Message Joseph Shraibman 2001-07-13 00:33:38 Re: news server access down?