Re: inserting columns with values from a different table - Mailing list pgsql-general

From Gregory Wood
Subject Re: inserting columns with values from a different table
Date
Msg-id 004601c10ec3$05866570$7889ffcc@comstock.com
Whole thread Raw
In response to Re: inserting columns with values from a different table  ("Gregory Wood" <gregw@com-stock.com>)
List pgsql-general
> > You could create D as a VIEW with what you need from A, B and C. Then
create
> > some RULEs on that view to perform your INSERTs, UPDATEs, and DELETEs.
> >
> > I'm not sure that will make your life easier, but that decision is yours
to
> > make :)
> >
>
> Ah updateable views, something for PG 7.2?

Nope, you can do them now, you just have to spell everything out explicitly
for PostgreSQL:

http://postgresql.bteg.net/users-lounge/docs/7.1/programmer/rules-insert.htm
l#AEN7370

I believe the feature you are referring to is the automatic generation of
RULEs for INSERTing, UPDATEing and DELETEing from VIEWs.

Greg


pgsql-general by date:

Previous
From: Andrew Gould
Date:
Subject: Re: MS Access 97 SR-1, psqlodbc 7.01.00.06, slow perfomance
Next
From: "Andras Balogh"
Date:
Subject: Re: VACUUM ANALYZE