pg_class(relpersistence) of hash index

From: Antonin Houska <ah(at)cybertec(dot)at>
To: pgsql-hackers(at)postgresql(dot)org
Subject: pg_class(relpersistence) of hash index
Date: 2014-11-24 14:05:19
Message-ID: 16590.1416837919@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

While checking how BM_PERMANENT flag is set (in buffer header), I noticed that
hash index has it set too. Shouldn't pg_class(relpersistence) be 'u' in this
case? Currently it's set to 'p':

postgres=# CREATE TABLE a(i int);
CREATE TABLE
postgres=# CREATE INDEX ON a USING HASH (i);
WARNING: hash indexes are not WAL-logged and their use is discouraged
CREATE INDEX
postgres=# \d a
Table "public.a"
Column | Type | Modifiers
--------+---------+-----------
i | integer |
Indexes:
"a_i_idx" hash (i)

postgres=# select relpersistence from pg_class where relname='a_i_idx';
relpersistence
----------------
p
(1 row)

--
Antonin Houska
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt
Web: http://www.postgresql-support.de, http://www.cybertec.at

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Petr Jelinek 2014-11-24 14:15:09 Re: no test programs in contrib
Previous Message Alvaro Herrera 2014-11-24 13:49:45 no test programs in contrib