Re: [HACKERS] create rule changes table to view ?
От | Bruce Momjian |
---|---|
Тема | Re: [HACKERS] create rule changes table to view ? |
Дата | |
Msg-id | 199909270008.UAA26148@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: [HACKERS] create rule changes table to view ? (Peter Eisentraut <peter_e@gmx.net>) |
Список | pgsql-hackers |
> I have noticed and lived with this problem for quite a while. > > There's nothing in pg_class that tells a table from a view, they're both > "relations". Since a view is implemented as in effect an empty table with > on select rules on it, psql thinks every table with a rule on it is a > view. This is just the output, nothing on the table changes. > > A fix would be to display both tables and views as "relation". As far as I > know there is now 100% deterministic way to tell a table from a view. I > think one fine day Jan is going to change that but for now we don't have > to worry about it. OK. Nothing added to TODO list. -- 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 по дате отправления: