Index: dlgView.cpp =================================================================== RCS file: /projects/pgadmin3/src/ui/dlgView.cpp,v retrieving revision 1.11 retrieving revision 1.12 diff -Lsrc/ui/dlgView.cpp -Lsrc/ui/dlgView.cpp -u -w -r1.11 -r1.12 --- src/ui/dlgView.cpp +++ src/ui/dlgView.cpp @@ -119,9 +119,6 @@ sql += wxT("ALTER TABLE ") + view->GetQuotedFullIdentifier() + wxT(" RENAME TO ") + qtIdent(name) + wxT(";\n"); } - if (cbOwner->GetValue() != view->GetOwner()) - sql += wxT("ALTER TABLE ") + qtIdent(name) - + wxT(" OWNER TO ") + qtIdent(cbOwner->GetValue()) + wxT(";\n"); } if (!view || txtSqlBox->GetText() != oldDefinition) @@ -131,6 +128,12 @@ + wxT(";\n"); } + if (view) + AppendOwnerChange(sql, wxT("TABLE ") + schema->GetQuotedPrefix() + qtIdent(name)); + else + AppendOwnerNew(sql, wxT("TABLE ") + schema->GetQuotedPrefix() + qtIdent(name)); + + sql += GetGrant(wxT("arwdRxt"), wxT("TABLE ") + schema->GetQuotedPrefix() + qtIdent(name)); AppendComment(sql, wxT("VIEW"), schema, view);