Active Record doesn''t appear to have support for table inheritance implemented in PostgreSQL as described in http://www.postgresql.org/docs/8.0/interactive/ddl-inherit.html. Is anyone working on such a thing or is their some compelling reason to avoid this feature? I am new to Ruby and Rails, but it doesn''t seem like it would be to difficult to adapt the current Active Record table inheritance model to work right with PostgreSQL. The hidden tableoid column is basicly equivalent to the Active Record type column, but it must be joined with the pg_class table to get an actual table/class name. -- Quinn Harris quinn-1F3SigAhSoJeoWH0uzbU5w@public.gmane.org
On 5/1/05, Quinn Harris <quinn-1F3SigAhSoJeoWH0uzbU5w@public.gmane.org> wrote:> Active Record doesn''t appear to have support for table inheritance implemented > in PostgreSQL as described in > http://www.postgresql.org/docs/8.0/interactive/ddl-inherit.html. > > Is anyone working on such a thing or is their some compelling reason to avoid > this feature?I''m sure it probably _could_ be made to work with Rails -- however, PostgreSQL''s table inheritance model is fundamentally broken, and most people here would probably tell you to avoid it. -- Regards, John Wilger ----------- Alice came to a fork in the road. "Which road do I take?" she asked. "Where do you want to go?" responded the Cheshire cat. "I don''t know," Alice answered. "Then," said the cat, "it doesn''t matter." - Lewis Carrol, Alice in Wonderland
In article <a05e51b605050113321ae6594a-JsoAwUIsXosN+BqQ9rBEUg@public.gmane.org>, johnwilger- Re5JQEeQqe8AvxtiuMwx3w-XMD5yJDbdMReXY1tMh2IBg@public.gmane.org says...> I''m sure it probably _could_ be made to work with Rails -- however, > PostgreSQL''s table inheritance model is fundamentally broken, and most > people here would probably tell you to avoid it.Which reminds me - back in November you''d threatened to code some really nice Class Table Inheritance support for ActiveRecord. Did anything ever come of that? -- Jay Levitt | Wellesley, MA | I feel calm. I feel ready. I can only Faster: jay at jay dot fm | conclude that''s because I don''t have a http://www.jay.fm | full grasp of the situation. - Mark Adler