On 19 nov., 16:36, t...@xxxxxxxxxxxxx (Tom Lane) wrote: > Tech 2010 <tch...@xxxxxxxxx> writes: > >> xy=# reindex table xy_data; > >> ERROR: concurrent insert in progress > > Should I drop and recreate indexes? > > I think that database is pretty well hosed. (What happened to it to > cause all this, anyway?) A dump/initdb/reload is probably indicated > at this point. reindex did not help. pg_dump crashes and select * into new_tables crashes as well. Any idea? Thanks. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general