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

On Thu, Nov 03, 2011 at 03:19:36PM +0100, Alban Hertroys wrote:
> 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.

sure. but so isn't create table as.

Best regards,

depesz

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