Александр Карев wrote : > > Hello All! Please heeeelp! > > I'm having problems on updating simple, as I think, view; > Also note: In view, there are labels which are in russian > text, in UNICODE. > > create table A1.Person ( > id serial primary key, > > firstname varchar(64) unicode not null, > secondname varchar(64) unicode, > surname varchar(64) unicode not null, > > date_of_insert timestamp not null default timestamp ) > // > create table A1.Student ( > id fixed(10) primary key references A1.Person(id) on delete > cascade ) > // > create or replace view A1.students_view as > select A1.Person.id, > A1.Person.firstname as "Имя", > A1.Person.secondname as "Отчество", > A1.Person.surname as "Фамилия", > A1.Person.address as "Адрес", > A1.Person.tel as "Телефон" > from A1.Person,A1.Student where A1.Person.id = A1.Student.id > > Now while updating second column of view (labeled "Отчество" ) > update A1.students_view set "Отчество" = 'тест' where id = 7 > returns error: -5001 POS(8) Missing privilege:UPDATE >
For updatable join views please have a look into the documentation : http://dev.mysql.com/doc/maxdb/en/c7/12ffe306ab11d3a97d00a0c9449261/frameset.htm It seems that the WITH CHECK OPTION is missing in your view definition. Best Regards, Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
