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

On Fri, Nov 04, 2011 at 05:49:44PM -0400, Tom Lane wrote:
> You said that pg_dump does not show the corruption.  That could be
> because the data is coming out through the COPY code path instead of
> the SELECT code path.  Could you try a pg_dump with --inserts (which
> will fetch the data with SELECTs) and see if it shows corrupt data?

Sure. Testing.

> Another thing we probably should ask at this point is whether you have
> any nonstandard software loaded into your server, like auto_explain
> or pg_stat_statements or some such.

No. Nothing like this. Just base Pg.

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/