From: | José Soares <jose(at)sferacarta(dot)com> |
---|---|
To: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] create rule changes table to view ? |
Date: | 1999-09-24 13:19:52 |
Message-ID: | 37EB7A78.A5AA913@sferacarta.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Bruce Momjian ha scritto:
> Can someone comment on this?
This an old question.
psql suppose that table "test" is a view because it checks for pg_class.relhasrules and it prints "view?"
if the value is TRUE and the value is if there's a rule for the table.
The only way to distinguish a table from a view is the pg_get_viewdef.
Some time ago I suggested to use pg_get_viewdef('tablename') to check for views
to print "view or table" instead of "view?".
I made a patch to my psql and it now recognize views perfectly and I can display
only tables using \d and/or only views using \v
Comments.
>
>
> > 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(at)sai(dot)msu(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
>
> ************
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 1999-09-24 14:21:20 | Re: [HACKERS] Re: [GENERAL] Update of bitmask type |
Previous Message | José Soares | 1999-09-24 13:01:19 | Re: [HACKERS] Re: [GENERAL] Update of bitmask type |