Re: WARNING: concurrent insert in progress within table "resource"

On Sun, Feb 26, 2012 at 10:04 AM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
> Hello
>
> I tested creating some larger indexes
>
> There was a warning:
>
> postgres=# CREATE INDEX idx_resource_name ON resource (name, tid);
> WARNING:  concurrent insert in progress within table "resource"
>
> I am sure so there was only one active session - so this warning is strange.
>
>
> postgres=# select version();
>                                                 version
> ──────────────────────────────────────────────────────────────────────────────────────────────────────────
>  PostgreSQL 9.2devel on i686-pc-linux-gnu, compiled by gcc (GCC) 4.5.1
> 20100924 (Red Hat 4.5.1-4), 32-bit
> (1 row)
>
> Regards
>
> Pavel

That seems bad. But can you provide any more details about how to reproduce it?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company