Re: [HACKERS] create rule changes table to view ?
От | Bruce Momjian |
---|---|
Тема | Re: [HACKERS] create rule changes table to view ? |
Дата | |
Msg-id | 199909231727.NAA19787@candle.pha.pa.us обсуждение исходный текст |
Ответ на | create rule changes table to view ? (Oleg Bartunov <oleg@sai.msu.su>) |
Ответы |
Re: [HACKERS] create rule changes table to view ?
|
Список | pgsql-hackers |
Can someone comment on this? > I just began to learn rules with 6.5 and notice: > test=> \dt > Database = test > +------------------+----------------------------------+----------+ > | Owner | Relation | Type | > +------------------+----------------------------------+----------+ > | megera | access_log | table | > | megera | hits | table | > | megera | junk_qwerty | table | > +------------------+----------------------------------+----------+ > > test=> create rule log_hits as on update to hits do instead insert into hits values ( NEW.msg_id, 1); > CREATE > test=> \dt > Database = test > +------------------+----------------------------------+----------+ > | Owner | Relation | Type | > +------------------+----------------------------------+----------+ > | megera | access_log | table | > | megera | hits | view? | > | megera | junk_qwerty | table | > +------------------+----------------------------------+----------+ > > Table hits now becomes view ? > > > Regards, > > Oleg > > _____________________________________________________________ > Oleg Bartunov, sci.researcher, hostmaster of AstroNet, > Sternberg Astronomical Institute, Moscow University (Russia) > Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ > phone: +007(095)939-16-83, +007(095)939-23-83 > > > -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
В списке pgsql-hackers по дате отправления: