Thread: BUG #14336: Using rls on a table, suddenly the table is missing
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDMzNgpMb2dnZWQgYnk6ICAg ICAgICAgIFBldGVycyBBbGFpbgpFbWFpbCBhZGRyZXNzOiAgICAgIGFsYWlu X3BldGVyc0B5YWhvby5mcgpQb3N0Z3JlU1FMIHZlcnNpb246IDkuNS40Ck9w ZXJhdGluZyBzeXN0ZW06ICAgMi42LjMyLTY0Mi5lbDYueDg2XzY0IEdOVS9M aW51eApEZXNjcmlwdGlvbjogICAgICAgIAoKSSBoYXZlIGRlZmluZSBhIHJs cyBvbiBhIHRhYmxlIGNhbGxlZCBhbGFpbi4gSSB0ZXN0IHRoZSBybHMgYW5k IEkgZG9uJ3QKa25vd24gd2h5LCBzdWRkZW5seSB0aGUgdGFibGUgZGlzYXBw ZWFyIC4gIFRoIHRhYmxlIGlzIG1pc3NpbmcgYnV0IHdoZW4gSQp0cnkgdG8g cmVjcmVhdGUgaXQgLCAgaSByZWNlaXZlIHRoZSBmb2xsb3dpbmcgbWVzc2Fn ZSA6IEVSUk9SOiAgdHlwZSAiYWxhaW4iCmFscmVhZHkgZXhpc3RzDQpISU5U OiAgQSByZWxhdGlvbiBoYXMgYW4gYXNzb2NpYXRlZCB0eXBlIG9mIHRoZSBz YW1lIG5hbWUsIHNvIHlvdSBtdXN0IHVzZSBhCm5hbWUgdGhhdCBkb2Vzbid0 IGNvbmZsaWN0IHdpdGggYW55IGV4aXN0aW5nIHR5cGUuDQoNClRhYmxlIG5h bWUgZG9lc24ndCBleGlzdCBpbiBwZ190YWJsZXMgYnV0IGNhbiBiZSByZXRy aXZlIGluIHBnX3R5cGUgLiANCg0KSXQncyBub3QgcG9zc2libGUgdG8gZHJv cCB0aGUgcG9saWN5IGFzc29jaWF0ZWQgd2l0aCB0aGUgdGFibGUgdGhhdCBo YXMKZGlzc2FwZWFyZWQuICBJIGhhdmUgcmV0cmlldmVkIHRoZSBkYXRhICAg IA0Kb2YgdGhlIHRhYmxlIHRoYXQgaXMgbWlzc2luZyBpbiBhIHRhYmxlIA0K Y2FsbGVkIHBnX2NhdGFsb2cucGdfcm93c2VjdXJpdHkuDQoNCk15IHF1ZXN0 aW9uIDogaG93IHRvIHJlbmFtZSB0aGUgdGFibGUgcGdfY2F0YWxvZy5wZ19y b3dzZWN1cml0eSB0byBhbGFpbgoobmFtZSBvZiB0aGUgdGFibGUgbWlzc2lu ZykgPyANCg0KS2luZCByZWdhcmRzIA0KDQpBbGFpbiBQZXRlcnMgKHppZWds ZXIgR3JvdXAgQmVsZ2l1bSkKCg==
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