Log Message:
-----------
sequence fixes
Modified Files:
--------------
pgadmin3/src/ui:
dlgSequence.cpp (r1.26 -> r1.27)
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)
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
