From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Strange problem with create table as select * from table; |
Date: | 2011-11-05 12:10:58 |
Message-ID: | 20111105121058.GA30287@depesz.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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?
pg_dump finished. all ids are correct - i.e. there are no rows with
xobject_id = -1.
Best regards,
depesz
--
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/
From | Date | Subject | |
---|---|---|---|
Next Message | hubert depesz lubaczewski | 2011-11-05 12:38:35 | Re: Strange problem with create table as select * from table; |
Previous Message | Steve Murphy | 2011-11-05 04:51:14 | What is *wrong* with this query??? |
From | Date | Subject | |
---|---|---|---|
Next Message | hubert depesz lubaczewski | 2011-11-05 12:38:35 | Re: Strange problem with create table as select * from table; |
Previous Message | Magnus Hagander | 2011-11-05 12:03:41 | Re: Show statistics target in \d+ |