Inherits is not encouraged? - Mailing list pgsql-sql

From Emi Lu
Subject Inherits is not encouraged?
Date
Msg-id 49B579AE.6060501@encs.concordia.ca
Whole thread Raw
Responses Re: Inherits is not encouraged?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Good morning,

I have two questions about inherits under postgreSQL 8.0.15.


(1) Is possible that I could change the column of a table that is 
defined by Inherits?

e.g., t1(col1, col2, col3); create table tx(colx) Inherits (t1)
I'd like to get tx shown as (col1, colx, col2, col3).


(2) Logically, I have a table inherited from two other tables, but no 
more other columns. Will it not be encouraged to do so?

e.g., t1 (col1... coln)     t2 (col1... coln)
     create t3() Inherits (t1, t2) without OID


Thanks a lot!
Lu Ying




pgsql-sql by date:

Previous
From: Andreas Wenk
Date:
Subject: Re: [PHP]
Next
From: Tom Lane
Date:
Subject: Re: Inherits is not encouraged?