[SQLObject] Inserting Into Views With PostgreSQL

[CLIFFORD I. <cli...@di...>]

Hi,

I really like the way that Oracle treats views as if they were virtual 
tables and will allow one to do INSERT, UPDATE, and DELETE operations on 
them and I equally dislike the way that PostgreSQL deals with views. It is 
NOT straightforward at all. Is there some way using SQLObject that we can 
abstract out the awkwardness of views in PostgreSQL. For example, say we 
have a classic master/detail relationship, invoice headers and invoice 
details. In Oracle, I would create a view called invoices and simply treat 
it as if it were a table. Can I do something like the following in SQLObject?

class(Invoice):
         <define "view" like structure here>

inv = Invoice.new(bla, bla, bla)

Some of these views can abstract a fairly complex relationship consisting 
of many tables being joined. It is much nicer having to deal with the 
abstraction than having to deal with the underlying tables.

Regards,

Clifford Ilkay
Dinamis Corporation
3266 Yonge Street, Suite 1419
Toronto, Ontario
Canada M4N 3P6

Tel: 416-410-3326