From: | Nabil Sayegh <postgresql(at)e-trolley(dot)de> |
---|---|
To: | Rudi Starcevic <rudi(at)oasis(dot)net(dot)au> |
Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Address Table |
Date: | 2003-06-27 13:10:35 |
Message-ID: | 1056719435.3251.10.camel@billy |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Am Fre, 2003-06-27 um 02.26 schrieb Rudi Starcevic:
> Hi,
>
> Just one other thing.
> With the senario below it's possible to have addresses without a link
> to any Park.
>
> Say if I remove a Park then it's row in the parks_address table still
> exists.
It isn't "it's" row.
It doesnt belong to this 1 park.
There could be another park which uses it (maybe in future).
I would kust let it stay there.
First of all, to make it clearer, I wouldn't call the table:
parks_address
Because this is misleading. The Table is just an
address
table. It doesnt store any information about parks. There could be many
more tables which 'use' addresses (Cinemas, Restaurants).
> I guess I just need to write a script to look for lonely addresses ?
>
> Does that sound OK ?
Well, I personally wouldn't. But of course you could.
HTH
--
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de
From | Date | Subject | |
---|---|---|---|
Next Message | Nabil Sayegh | 2003-06-27 13:19:33 | Re: Address Table |
Previous Message | Michael Hanna | 2003-06-27 12:58:15 | Re: authentication questions |