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

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

On 11/04/2011 01:17 PM, hubert depesz lubaczewski wrote:
> On Thu, Nov 03, 2011 at 11:03:45PM +0100, hubert depesz lubaczewski wrote:
>> looking for some other info. will post as soon as i'll gather it, but
>> that will be in utc morning :(
>
>
> I looked closer at the rows that got -1 xobject_id.

>
> Does it tell you anything?

You are very thorough.
I don't know enough about Postgres internals to be much help there. All
I can point out is the problem seemed to appear over roughly a two month
period 5/28/11-7/20/11.
Any new code or procedures rolled out then?
Any bug reports?

Given the turnover on this table it seems important everything is
'normal' since 7/20/11.

>
> Best regards,
>
> depesz
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2011-11-04 20:47:22 Re: Strange problem with create table as select * from table;
Previous Message hubert depesz lubaczewski 2011-11-04 20:17:02 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 20:47:22 Re: Strange problem with create table as select * from table;
Previous Message hubert depesz lubaczewski 2011-11-04 20:17:02 Re: Strange problem with create table as select * from table;