Postgres Pro
Downloads
Home   >   mailing lists

Re: Strange problem with create table as select * from table; - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Strange problem with create table as select * from table;
Date
Msg-id CAF-3MvP5H2pdHy+DWK5KHpzp2rRjbr-4qg+cDj7e5bYgZSEVLA@mail.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;  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-general
Tree view 
On 3 November 2011 15:15, hubert depesz lubaczewski <depesz@depesz.com> wrote:
>> Do the xobject_id values have other negative numbers or is -1 just a special
>> case? The only thing I can think of is a corrupted index on xobject_id.
>
> minimal xobject_id in source table is 1000.
>
> index on xobject_id might be corrupted, but it doesn't explain that I
> don't see duplicates with group_by/having query on xobjects, which uses
> seqscan:

Actually, it does. A sequential scan doesn't use the index.

--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Strange problem with create table as select * from table;
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Strange problem with create table as select * from table;