hubert depesz lubaczewski <depesz@xxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
