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

Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> 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 this awhile back and deciding that it
was harder than it was worth. But if you can do it I have no objection.
(It might be easier now than it was then; I think there are fewer places
now that have hardwired knowledge about system columns than before.)

regards, tom lane