Re: inserting columns with values from a different table

Поиск
Список
Период
Сортировка
От Gregory Wood
Тема Re: inserting columns with values from a different table
Дата
Msg-id 004601c10ec3$05866570$7889ffcc@comstock.com
обсуждение исходный текст
Ответ на Re: inserting columns with values from a different table  ("Gregory Wood" <gregw@com-stock.com>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Gould
Дата:
Сообщение: Re: MS Access 97 SR-1, psqlodbc 7.01.00.06, slow perfomance
Следующее
От: "Andras Balogh"
Дата:
Сообщение: Re: VACUUM ANALYZE