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 201111031317.25481.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;  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
On Thursday, November 03, 2011 1:03:12 pm hubert depesz lubaczewski wrote:
> On Thu, Nov 03, 2011 at 10:55:20AM -0400, Tom Lane wrote:

>
> So, did some tests:
>

> as you can see counts of rows in created table are more or less
> sensible, but whatever method I used - create table as, insert into,
> using sychronized_scans (initially) or not (later) - copy of the table,
> as long as it's in database, has 40 those "-1" rows.

At least it is consistent:)
Characteristics of those forty rows.
1) creation_tsz  clustered?
2) magic_id in a range?
3) Non -1  xobject_id in a range?
4) Any other field show a similarity?


>
> one note - maybe it wasn't clear from my original mail - when I did
> pg_dump of the xobjects table, it didn't have -1 rows.

--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: Tony Capobianco
Date:
Subject: Re: pg_dump schma while excluding specific table
Next
From: Tom Lane
Date:
Subject: Re: Strange problem with create table as select * from table;