Message-ID: <408FA5EA.3020901@cs.msu.su>
Date: Wed, 28 Apr 2004 16:39:06 +0400
From: Alexey Borzov <borz_off@cs.msu.su>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.4) Gecko/20030624
MIME-Version: 1.0
To: Dave Page <dpage@vale-housing.co.uk>
Cc: pgsql-www@postgresql.org
Subject: Re: Some more questions on DB schema
References: <03AF4E498C591348A42FC93DEA9661B889FB6D@mail.vale-housing.co.uk>
In-Reply-To: <03AF4E498C591348A42FC93DEA9661B889FB6D@mail.vale-housing.co.uk>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Hi!

Dave Page wrote:
>>1) What is the table 'dellog' for?
> 
> It's a leftover from the old search engine iirc. I assume there's noting
> interesting in it? If not, it can go.

Yep, the table is empty.

>>2) Why 'comments' table does not have a foreign key on 'docs'?
> 
> Oversight I guess. Feel free to add one.

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.