Re: Some more questions on DB schema

> -----Original Message-----
> From: Alexey Borzov [mailto:borz_off(at)cs(dot)msu(dot)su]
> Sent: 28 April 2004 13:39
> To: Dave Page
> Cc: pgsql-www(at)postgresql(dot)org
> Subject: Re: [pgsql-www] Some more questions on DB schema
>
>
> There are some problems with this... Run the following query
>
> SELECT id, version, file
> FROM comments c
> WHERE NOT EXISTS (
> SELECT id
> FROM docs d
> WHERE d.version = c.version AND
> d.file = c.file
> );
>
> and observe the comments that are linked to non-existant
> pages of documentation. Someone'll have to fix these before
> adding a foreign key will be possible.

Fixed, fkey added.

Regards, Dave.