On Mon, Jun 16, 2008 at 10:24 PM, Richard Broersma <richard.broersma@xxxxxxxxx> wrote: > On Mon, Jun 16, 2008 at 8:32 PM, Michael Shiulman <shulman@xxxxxxxxxxxx> wrote: > Anyway, here is a link discussing a generalized vertical partitioned > view. Perhaps it can give you some idea to get yourself rolling. > http://archives.postgresql.org/pgsql-general/2006-12/msg01119.php Oops, there is one other thing to bring up. If your clients front-ends use a form of Optimistic locking, they will probably balk at update-able views on vertically partitioned joined tables. However, in the case of using ODBC, there was a work-around that solved the problem of optimistic locking. However, you are still faced with the problem of update anomalies caused by concurrent updates on your base tables. http://archives.postgresql.org/pgsql-odbc/2006-12/msg00029.php -- Regards, Richard Broersma Jr. Visit the Los Angles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug
