Log Message:
-----------
Fix changing of view ownership
Modified Files:
--------------
pgadmin3/src/ui:
dlgView.cpp (r1.11 -> r1.12)
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);
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
