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

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