Skip site navigation (1) Skip section navigation (2)

ALTER INDEX broken in CVS head?

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 (view raw or flat)
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

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2004-08-31 16:13:57
Subject: Re: ALTER INDEX broken in CVS head?
Previous:From: PostgreSQL Bugs ListDate: 2004-08-31 14:50:03
Subject: BUG #1237: text_field like 'abc%' not using index on text_field

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group