| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | depesz(at)depesz(dot)com |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Strange problem with create table as select * from table; |
| Date: | 2011-11-05 00:06:35 |
| Message-ID: | 201111041706.36283.adrian.klaver@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-11-05 01:04:02 | Re: Strange problem with create table as select * from table; |
| Previous Message | Tom Lane | 2011-11-04 23:04:34 | Re: Strange problem with create table as select * from table; |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-11-05 01:04:02 | Re: Strange problem with create table as select * from table; |
| Previous Message | Tom Lane | 2011-11-04 23:04:34 | Re: Strange problem with create table as select * from table; |