Обсуждение: BUG #14336: Using rls on a table, suddenly the table is missing

Поиск
Список
Период
Сортировка

BUG #14336: Using rls on a table, suddenly the table is missing

От
alain_peters@yahoo.fr
Дата:
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDMzNgpMb2dnZWQgYnk6ICAg
ICAgICAgIFBldGVycyBBbGFpbgpFbWFpbCBhZGRyZXNzOiAgICAgIGFsYWlu
X3BldGVyc0B5YWhvby5mcgpQb3N0Z3JlU1FMIHZlcnNpb246IDkuNS40Ck9w
ZXJhdGluZyBzeXN0ZW06ICAgMi42LjMyLTY0Mi5lbDYueDg2XzY0IEdOVS9M
aW51eApEZXNjcmlwdGlvbjogICAgICAgIAoKSSBoYXZlIGRlZmluZSBhIHJs
cyBvbiBhIHRhYmxlIGNhbGxlZCBhbGFpbi4gSSB0ZXN0IHRoZSBybHMgYW5k
IEkgZG9uJ3QKa25vd24gd2h5LCBzdWRkZW5seSB0aGUgdGFibGUgZGlzYXBw
ZWFyIC4gIFRoIHRhYmxlIGlzIG1pc3NpbmcgYnV0IHdoZW4gSQp0cnkgdG8g
cmVjcmVhdGUgaXQgLCAgaSByZWNlaXZlIHRoZSBmb2xsb3dpbmcgbWVzc2Fn
ZSA6IEVSUk9SOiAgdHlwZSAiYWxhaW4iCmFscmVhZHkgZXhpc3RzDQpISU5U
OiAgQSByZWxhdGlvbiBoYXMgYW4gYXNzb2NpYXRlZCB0eXBlIG9mIHRoZSBz
YW1lIG5hbWUsIHNvIHlvdSBtdXN0IHVzZSBhCm5hbWUgdGhhdCBkb2Vzbid0
IGNvbmZsaWN0IHdpdGggYW55IGV4aXN0aW5nIHR5cGUuDQoNClRhYmxlIG5h
bWUgZG9lc24ndCBleGlzdCBpbiBwZ190YWJsZXMgYnV0IGNhbiBiZSByZXRy
aXZlIGluIHBnX3R5cGUgLiANCg0KSXQncyBub3QgcG9zc2libGUgdG8gZHJv
cCB0aGUgcG9saWN5IGFzc29jaWF0ZWQgd2l0aCB0aGUgdGFibGUgdGhhdCBo
YXMKZGlzc2FwZWFyZWQuICBJIGhhdmUgcmV0cmlldmVkIHRoZSBkYXRhICAg
IA0Kb2YgdGhlIHRhYmxlIHRoYXQgaXMgbWlzc2luZyBpbiBhIHRhYmxlIA0K
Y2FsbGVkIHBnX2NhdGFsb2cucGdfcm93c2VjdXJpdHkuDQoNCk15IHF1ZXN0
aW9uIDogaG93IHRvIHJlbmFtZSB0aGUgdGFibGUgcGdfY2F0YWxvZy5wZ19y
b3dzZWN1cml0eSB0byBhbGFpbgoobmFtZSBvZiB0aGUgdGFibGUgbWlzc2lu
ZykgPyANCg0KS2luZCByZWdhcmRzIA0KDQpBbGFpbiBQZXRlcnMgKHppZWds
ZXIgR3JvdXAgQmVsZ2l1bSkKCg==

Re: BUG #14336: Using rls on a table, suddenly the table is missing

От
Alvaro Herrera
Дата:
alain_peters@yahoo.fr wrote:
> The following bug has been logged on the website:
>
> Bug reference:      14336
> Logged by:          Peters Alain
> Email address:      alain_peters@yahoo.fr
> PostgreSQL version: 9.5.4
> Operating system:   2.6.32-642.el6.x86_64 GNU/Linux
> Description:
>
> I have define a rls on a table called alain. I test the rls and I don't
> known why, suddenly the table disappear.

Can you provide the precise SQL commands that you ran to achieve this?
I don't think this is expected, but without a means to reproduce it
we're unable to verify what is going on.

--
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services