[HACKERS] What's the meaning of system column in views

2002-05-13 Thread Hiroshi Inoue
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 --+--+--+--+--+-- | | | | | | | | | | | | |

Re: [HACKERS] What's the meaning of system column in views

2002-05-13 Thread Tom Lane
Hiroshi Inoue [EMAIL PROTECTED] writes: # 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. I seem to recall having looked at