Index: dlgSequence.cpp =================================================================== RCS file: /projects/pgadmin3/src/ui/dlgSequence.cpp,v retrieving revision 1.26 retrieving revision 1.27 diff -Lsrc/ui/dlgSequence.cpp -Lsrc/ui/dlgSequence.cpp -u -w -r1.26 -r1.27 --- src/ui/dlgSequence.cpp +++ src/ui/dlgSequence.cpp @@ -159,8 +159,8 @@ } if (sequence->GetOwner() != cbOwner->GetValue()) { - sql += wxT("ALTER TABLE ") + sequence->GetQuotedFullIdentifier() - + wxT(" OWNER TO ") + qtIdent(name) + wxT(";\n"); + sql += wxT("ALTER TABLE ") + schema->GetQuotedPrefix() + qtIdent(name) + + wxT(" OWNER TO ") + qtIdent(cbOwner->GetValue()) + wxT(";\n"); } if (connection->BackendMinimumVersion(7, 4)) @@ -206,9 +206,9 @@ else { if (txtStart->GetValue() != sequence->GetLastValue().ToString()) - sql += wxT("SELECT setval('") + qtString(schema->GetName()) + wxT(".") + qtString(name) + sql += wxT("SELECT setval('") + qtIdent(schema->GetName()) + wxT(".") + qtIdent(name) + wxT("', ") + txtStart->GetValue() - + wxT(");\n"); + + wxT(", false);\n"); } if (cbTablespace->GetValue() != sequence->GetTablespace()) sql += wxT("ALTER TABLE ") + schema->GetQuotedPrefix()+ qtIdent(name)