Re: inserting columns with values from a different table

From: "Gregory Wood" <gregw(at)com-stock(dot)com>
To: "PostgreSQL-General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: inserting columns with values from a different table
Date: 2001-07-17 13:18:16
Message-ID: 004601c10ec3$05866570$7889ffcc@comstock.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Fran Fabrizio 2001-07-17 13:24:17 Re: do i need a view or procedure?
Previous Message Ben-Nes Michael 2001-07-17 12:02:07 VACUUM ANALYZE