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