Skip site navigation (1) Skip section navigation (2)

Re: Some more questions on DB schema

From: Alexey Borzov <borz_off(at)cs(dot)msu(dot)su>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: pgsql-www(at)postgresql(dot)org
Subject: Re: Some more questions on DB schema
Date: 2004-04-28 12:39:06
Message-ID: 408FA5EA.3020901@cs.msu.su (view raw or flat)
Thread:
Lists: pgsql-www
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.



In response to

pgsql-www by date

Next:From: Dave PageDate: 2004-04-28 12:48:45
Subject: Re: Some more questions on DB schema
Previous:From: Jean-Michel POUREDate: 2004-04-28 08:13:27
Subject: Re: [HACKERS] What can we learn from MySQL?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group