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 (
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.
In response to
pgsql-www by date
|Next:||From: Dave Page||Date: 2004-04-28 12:48:45|
|Subject: Re: Some more questions on DB schema|
|Previous:||From: Jean-Michel POURE||Date: 2004-04-28 08:13:27|
|Subject: Re: [HACKERS] What can we learn from MySQL?|