What's the meaning of system column in views
От | Hiroshi Inoue |
---|---|
Тема | What's the meaning of system column in views |
Дата | |
Msg-id | 3CE05BB3.9B83B464@tpf.co.jp обсуждение исходный текст |
Ответы |
Re: What's the meaning of system column in views
|
Список | pgsql-hackers |
Hi all, I see the following for a view a_view; # select ctid, xmin, cmin, xmax, cmax, tableoid from a_view;ctid | xmin | cmin | xmax | cmax | tableoid ------+------+------+------+------+---------- | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | (8 rows) All system columns are null and seem to have no meaning to me. In addition it's also annoying to me e.g. # create view aview as select ctid, * from a_table; ERROR: name of column "ctid" conflicts with an existing system column If there's no objection I would remove system columns from views and allow the second example. regards, Hiroshi Inouehttp://w2422.nsk.ne.jp/~inoue/
В списке pgsql-hackers по дате отправления: