Hey Matthew,
2013/6/14 Matthew Sherborne <msherbo...@gmail.com>
> So I have two questions here:
>
> 1. Has anyone used witty with pg table inheritance ? if so how please ?
>
Just curious, what task you're trying to solve?
AFAIK, table inheritance in Postgres usually used for table partitioning,
rather
than object-oriented database design. It is a pretty old feature that does
not
improved for years. The main limitation for using table inheritance in OOP
is
lack of integration with unique constraints and foreign keys.
See here for details:
http://www.postgresql.org/docs/9.3/static/ddl-inherit.html
If you want to make you database design "object-oriented", I recommend you
to use views (with rules and triggers to make it updatable). Btw, there are
automatically
updatable and materialized views as of 9.3 which a little bit simplifies
this approach.
See here for details:
http://www.postgresql.org/docs/9.3/static/rules-views.html#RULES-VIEWS-UPDATE
--
// Dmitriy.
------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:
Build for Windows Store.
http://p.sf.net/sfu/windows-dev2dev
_______________________________________________
witty-interest mailing list
witty-interest@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/witty-interest
