Ian Lawrence Barwick <barw...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
