Postgres Pro
Downloads
Home   >   mailing lists

Re: Strange problem with create table as select * from table; - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Strange problem with create table as select * from table;
Date
Msg-id 201111041706.36283.adrian.klaver@gmail.com
Whole thread Raw
In response to Re: Strange problem with create table as select * from table;  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: Strange problem with create table as select * from table;  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-general
Tree view 
On Friday, November 04, 2011 3:43:48 pm hubert depesz lubaczewski wrote:
> 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?
>
> i'm running the pg_dump (it will take some time, so don't hold your
> breath), but at the same time - I can select these rows, correctly, with
> normal SELECT from table (xobjects table). Doesn't it disprove this
> theory?

Another question.
Between 07/20/11 and this recent attempt did you do a CREATE TABLE AS on this
table and not have corrupted rows?

>
> Best regards,
>
> depesz

--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strange problem with create table as select * from table;
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Strange problem with create table as select * from table;