BUG #14158: PostgreSQL 9.6 bloom don't support unlogged table?

In bool\blinsert.c, the function "blbuildempty" the if test failed. And, in
catlog\index.c line 2037, after creating the index file, then to build
empty index file. but we got the "one" block number of the relation, that
lead the if test failed.

On Wed, May 25, 2016 at 5:54 PM, <digoal@126.com> wrote:

digoal@126.com writes:

master=# create unlogged table tbl12(id int);
CREATE TABLE
master=# \set VERBOSITY verbose
master=# create index idx1 on tbl12 using bloom (id);
ERROR: XX000: index "idx1" already contains data
LOCATION: blbuildempty, blinsert.c:164

Isn't this a duplicate of bug #14155?

regards, tom lane

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

On Wed, May 25, 2016 at 7:16 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

digoal@126.com writes:

master=# create unlogged table tbl12(id int);
CREATE TABLE
master=# \set VERBOSITY verbose
master=# create index idx1 on tbl12 using bloom (id);
ERROR: XX000: index "idx1" already contains data
LOCATION: blbuildempty, blinsert.c:164

Isn't this a duplicate of bug #14155?

Yes, you already fixed that with abaffa90 yesterday.
--
Michael

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs