Re: Inheritance & multiple-value fields

Thanks for your input, Ron.

My question, however, is addressed to PG only since this is PG mailing list. I have no interest to buy another DB product at this moment.

My question can be stated in the other way: why the data in the sub-table is visible, but not referable?

Here is my example:

Table A ( id int, ... )
Table B ( ... ) inherits (A)

Table A1 ( id int REFERENCES A ON DELETE CASCADE, ...)

A selecting operation can retrieve data in the table B, but an inserting operation can't refer a key in the table B.

--

--------- Original Message ---------

DATE: 02 Aug 2003 17:09:12 -050
From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc:

>On Sat, 2003-08-02 at 15:26, Vernon Smith wrote:
>> We usually use another table for a multi-valued field. Is possible
>> having a single multi-valued field table for all tables in the
>> same heredity, other than having a multi-valued table for every
>> single tables in the heredity?
>
>Sure: Pick, now known as D3.
>http://www.rainingdata.com/products/dbms/d3/index.html
>
>However, that breaks the cardinal rule of relational DB design:
>http://www.databasejournal.com/sqletc/article.php/26861_1428511_4
>
>--
>+-----------------------------------------------------------------+
>| Ron Johnson, Jr. Home: ron(dot)l(dot)johnson(at)cox(dot)net |
>| Jefferson, LA USA |
>| |
>| "I'm not a vegetarian because I love animals, I'm a vegetarian |
>| because I hate vegetables!" |
>| unknown |
>+-----------------------------------------------------------------+
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

____________________________________________________________
Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!
http://login.mail.lycos.com/r/referral?aid=27005