Re: Index creation fails with automatic names

Ian Lawrence Barwick <barwick@gmail.com> wrote:

> It works fine for me on Pg 9.3.1:
>
> postgres=# CREATE TABLE foo(val1 text, val2 text);
> CREATE TABLE
> postgres=# CREATE INDEX on foo((lower(val1)));
> CREATE INDEX
> postgres=# CREATE INDEX on foo((lower(val2)));
> CREATE INDEX

You seem to be creating the indexes one at a time, all on the same
connection.  The OP's problem occurs when starting five CREATE
INDEX statements in five different sessions all at the same time.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company