--- src/schema/pgColumn.cpp.orig Fri Oct 3 00:22:25 2003 +++ src/schema/pgColumn.cpp Fri Oct 3 00:22:58 2003 @@ -69,7 +69,7 @@ if (!GetDefault().IsEmpty()) sql += wxT("ALTER TABLE ") + GetQuotedFullTable() + wxT(" ALTER COLUMN ") + GetQuotedIdentifier() - + wxT(" DEFAULT ") + GetDefault() + wxT(";\n"); + + wxT(" SET DEFAULT ") + GetDefault() + wxT(";\n"); if (!GetComment().IsEmpty()) sql += wxT("COMMENT ON COLUMN ") + GetQuotedFullTable() + wxT(".") + GetQuotedIdentifier() + wxT(" IS ") + qtString(GetComment()) + wxT(";\n");