| From: | Francisco J Reyes <fran(at)natserv(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Christopher Browne <cbbrowne(at)libertyrms(dot)info>, Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>, pgsql General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Domains (Was [PERFORM] Views With Unions) |
| Date: | 2003-08-01 17:26:47 |
| Message-ID: | 20030801131642.Q93127@zoraida.natserv.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jenny Zhang | 2003-08-01 18:04:10 | OSDL Database Test Suite 3 is available on PostgreSQL |
| Previous Message | Tom Lane | 2003-08-01 16:51:33 | Re: Views With Unions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2003-08-01 17:32:13 | Re: How number of columns affects performance |
| Previous Message | Francisco J Reyes | 2003-08-01 17:14:53 | Re: How number of columns affects performance |