You specify the inheritance on the creation of the child table. See CREATE TABLE
--elein On Wed, Feb 16, 2005 at 11:48:54PM +0300, Oleg Bartunov wrote: > Hi there, > > is't possible to make table to be inherited from another table in case > both tables already exist. I tried to insert record to pg_inherits, > but it doesn't helped. > > openfts=# select * from pg_inherits; > inhrelid | inhparent | inhseqno > ----------+-----------+---------- > 2617283 | 2417279 | 1 > > did I miss something ? > > Regards, > Oleg > _____________________________________________________________ > Oleg Bartunov, sci.researcher, hostmaster of AstroNet, > Sternberg Astronomical Institute, Moscow University (Russia) > Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ > phone: +007(095)939-16-83, +007(095)939-23-83 > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match