Re: Strange problem with create table as select * from table;

hubert depesz lubaczewski <depesz(at)depesz(dot)com> writes:
> i tried:
> create table qqq as select cmax as o_cmax, xmax as o_xmax, cmin as
> o_cmin, xmin as o_xmin, ctid as o_ctid, * from sssssss.xobjects;

> but the resulting table didn't have -1 values:

Oh, that's pretty interesting ... suggests that the targetlist has to be
exactly "select *". We have some minor optimizations for that case,
though nothing that could result in extra rows AFAICS.

Are there any dropped columns in the original table? Try

select * from pg_attribute where attrelid = 'sssssss.xobjects'::regclass
and attisdropped;

regards, tom lane