Re: Found a bug

Gurjeet Singh wrote:
> Hi All,
> 
>    Please refer the following session snippet. It seems that creating and
> dropping an index on a table, within a transaction, leaves the table marked
> as having an index. Although, I don't think it's a serious bug, since we
> always retrieve the list using RelationGetIndexList(), and that list turns
> out to be empty; but, if possible we should track it down.

Can't reproduce it here:

richardh=# create table t (a int);
CREATE TABLE
richardh=# begin;
BEGIN
richardh=# create index t_idx on t (a);
CREATE INDEX
richardh=# select relhasindex from pg_class where relname = 't'; relhasindex
------------- t
(1 row)

richardh=# rollback;
ROLLBACK
richardh=# select relhasindex from pg_class where relname = 't'; relhasindex
------------- f

PostgreSQL 8.1.3 on i586-pc-linux-gnu

--   Richard Huxton  Archonet Ltd