From: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> |
---|---|
To: | PostgreSQL Bugs List <pgsql-bugs(at)postgresql(dot)org> |
Subject: | ALTER INDEX broken in CVS head? |
Date: | 2004-08-31 15:07:31 |
Message-ID: | Pine.LNX.4.58.0408311701560.28337@sablons.cri.ensmp.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Dear debuggers,
Sorry again if it was already reported or it is a work in progress, but I
cannot have access to the list archives right now.
On my linux box with a cvs-head updated this morning:
sh> mkdir /tmp/postgres
psql> CREATE TABLESPACE foo LOCATION '/tmp/postgres';
psql> CREATE SCHEMA bla TABLESPACE foo;
psql> CREATE TABLE bla.t(id SERIAL PRIMARY KEY);
psql> ALTER INDEX bla.t_pkey SET TABLESPACE pg_default;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
@:
!>
then
psql> ALTER INDEX bla.t_pkey SET TABLESPACE pg_default;
ERROR: could not create relation 1663/19396/19473: File exists
So the state is pretty incoherent.
Well, I can still drop the database.
--
Fabien Coelho - coelho(at)cri(dot)ensmp(dot)fr
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-08-31 16:13:57 | Re: ALTER INDEX broken in CVS head? |
Previous Message | PostgreSQL Bugs List | 2004-08-31 14:50:03 | BUG #1237: text_field like 'abc%' not using index on text_field |