Re: Domains (Was [PERFORM] Views With Unions) - Mailing list pgsql-general

From Ron Johnson
Subject Re: Domains (Was [PERFORM] Views With Unions)
Date
Msg-id 1059782193.22384.85.camel@haggis
Whole thread Raw
In response to Domains (Was [PERFORM] Views With Unions)  (Francisco J Reyes <fran@natserv.net>)
Responses Inheritance vs child tables (Was Domains)
List pgsql-general
On Fri, 2003-08-01 at 12:26, Francisco J Reyes wrote:
> On Fri, 1 Aug 2003, Tom Lane wrote:
[snip]
> accros some tables. Currently I used inheritance to enforce the consitency
> since a good number of fields needed to be common among the tables AND the
> inheritted tables are basically a supperset of the data, so some times I
> would want to access the inheritted tables and other times the parent/main
> table.

Isn't this when you'd really want child tables, instead?

--
+-----------------------------------------------------------------+
| Ron Johnson, Jr.        Home: ron.l.johnson@cox.net             |
| Jefferson, LA  USA                                              |
|                                                                 |
| "I'm not a vegetarian because I love animals, I'm a vegetarian  |
|  because I hate vegetables!"                                    |
|    unknown                                                      |
+-----------------------------------------------------------------+



pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: How to do?
Next
From: markw@osdl.org
Date:
Subject: OSDL DBT-2 for PostgreSQL