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

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Strange problem with create table as select * from table;
Date: 2011-11-04 22:25:49
Message-ID: 20111104222549.GA21409@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Fri, Nov 04, 2011 at 06:18:55PM -0400, Tom Lane wrote:
> BTW, did you try the separate INSERT/SELECT yet? Does that show
> corruption?

pg_dump --inserts is still working.

i did create table (like), insert into ... select and it also shows the
problem, as I showed (with other data) in email:
20111103200312(dot)GA4510(at)depesz(dot)com

Best regards,

depesz

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Mincik 2011-11-04 22:26:59 PostgreSQL table history tracking
Previous Message Tom Lane 2011-11-04 22:18:55 Re: Strange problem with create table as select * from table;

Browse pgsql-hackers by date

  From Date Subject
Next Message hubert depesz lubaczewski 2011-11-04 22:43:48 Re: Strange problem with create table as select * from table;
Previous Message Tom Lane 2011-11-04 22:18:55 Re: Strange problem with create table as select * from table;