BUG #10949: Row security feature doesn't work.
От | a.magdenko@gmail.com |
---|---|
Тема | BUG #10949: Row security feature doesn't work. |
Дата | |
Msg-id | 20140714085713.2501.3963@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #10949: Row security feature doesn't work.
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 10949 Logged by: Alexander Magdenko Email address: a.magdenko@gmail.com PostgreSQL version: 9.4beta1 Operating system: Ubuntu 12.04 Description: Hello, I tried to install last Postgresql 9.4-beta version to check how RLS features works http://wiki.postgresql.org/wiki/Row-security I have installed 9.4 version on Ubuntu 12.04 (precise) like described here http://wiki.postgresql.org/wiki/Apt http://wiki.postgresql.org/wiki/Apt/FAQ#I_want_to_try_the_beta_version_of_the_next_PostgreSQL_release I checked that version is OK $ dpkg -l postgresql-9.4 ii postgresql-9.4 9.4~beta1-2.pgdg12.4+1 object-relational SQL database, version 9.4 server And in file /usr/share/doc/postgresql-9.4/changelog.gz first strings * Rebuild for precise-pgdg (jenkins-postgresql-9.4-source- distribution=precise-124, bzr revision 470) -- apt.postgresql.org autobuilder <myon@debian.org> Fri, 30 May 2014 20:26:51 +0200 But when I created database 'mydb' with table CREATE TABLE my_order ( my_order_id bigint PRIMARY KEY, name text, descr text, owner text default current_user ); I always get syntax error for ALTER TABLE my_order SET ROW SECURITY FOR ALL TO (owner = current_user); ERROR: syntax error at or near "ROW" SQL-state: 42601 Symbol: 77 Why this syntax doesn't work in beta release? And how to install it with RLS support? We are going to include these features in production system with Postgresql soon. Any help?
В списке pgsql-bugs по дате отправления: