pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Domains (Was [PERFORM] Views With Unions)
2+ messages / 2 participants
[nested] [flat]

* Domains (Was [PERFORM] Views With Unions)
@ 2003-08-01 17:26 Francisco J Reyes <fran@natserv.net>
  2003-08-01 23:56 ` Re: Domains (Was [PERFORM] Views With Unions) Ron Johnson <ron.l.johnson@cox.net>
  0 siblings, 1 reply; 2+ messages in thread

From: Francisco J Reyes @ 2003-08-01 17:26 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Christopher Browne <cbbrowne@libertyrms.info>; Stephan Szabo <sszabo@megazone.bigpanda.com>; pgsql General List <pgsql-general@postgresql.org>

On Fri, 1 Aug 2003, Tom Lane wrote:

> Domains were a work-in-progress in 7.3, and to some extent still are.
> Please try to test out 7.4beta and let us know about deficiencies you
> find.

Are domains user defined types? That they seem to be based on what I see
on the docs.

Any drawbacks to using them?

Right now I have a new database I am making and wanted some consistency
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.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Domains (Was [PERFORM] Views With Unions)
  2003-08-01 17:26 Domains (Was [PERFORM] Views With Unions) Francisco J Reyes <fran@natserv.net>
@ 2003-08-01 23:56 ` Ron Johnson <ron.l.johnson@cox.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Ron Johnson @ 2003-08-01 23:56 UTC (permalink / raw)
  To: pgsql General List <pgsql-general@postgresql.org>

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                                                      |
+-----------------------------------------------------------------+





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2003-08-01 23:56 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-08-01 17:26 Domains (Was [PERFORM] Views With Unions) Francisco J Reyes <fran@natserv.net>
2003-08-01 23:56 ` Ron Johnson <ron.l.johnson@cox.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox