Обсуждение: BUG #14158: PostgreSQL 9.6 bloom don't support unlogged table?
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDE1OApMb2dnZWQgYnk6ICAg ICAgICAgIFpob3UgRGlnb2FsCkVtYWlsIGFkZHJlc3M6ICAgICAgZGlnb2Fs QDEyNi5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiA5LjZiZXRhMQpPcGVyYXRp bmcgc3lzdGVtOiAgIENlbnRPUyA2LnggeDY0CkRlc2NyaXB0aW9uOiAgICAg ICAgCgptYXN0ZXI9IyBjcmVhdGUgZXh0ZW5zaW9uIGJsb29tOw0KQ1JFQVRF IEVYVEVOU0lPTiAgICAgICAgICAgICAgICAgICAgICAgICAgXg0KbWFzdGVy PSMgY3JlYXRlIHVubG9nZ2VkIHRhYmxlIHRibDEyKGlkIGludCk7DQpDUkVB VEUgVEFCTEUNCg0KbWFzdGVyPSMgXHNldCBWRVJCT1NJVFkgdmVyYm9zZQ0K bWFzdGVyPSMgY3JlYXRlIGluZGV4IGlkeDEgb24gdGJsMTIgdXNpbmcgYmxv b20gKGlkKTsNCkVSUk9SOiAgWFgwMDA6IGluZGV4ICJpZHgxIiBhbHJlYWR5 IGNvbnRhaW5zIGRhdGENCkxPQ0FUSU9OOiAgYmxidWlsZGVtcHR5LCBibGlu c2VydC5jOjE2NAoK
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: > The following bug has been logged on the website: > > Bug reference: 14158 > Logged by: Zhou Digoal > Email address: digoal@126.com > PostgreSQL version: 9.6beta1 > Operating system: CentOS 6.x x64 > Description: > > master=# create extension bloom; > CREATE EXTENSION ^ > 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 > > > -- > Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-bugs >
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
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