schema/spacewalk/spacewalk-schema-upgrade | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
New commits:
commit 7bc6c0f577f5a8a292123f75cb8933a0c9aff2e6
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Thu Jan 20 18:25:27 2011 +0100
Use current_timestamp which works on both database backends.
diff --git a/schema/spacewalk/spacewalk-schema-upgrade
b/schema/spacewalk/spacewalk-schema-upgrade
index 5b443e0..1499d05 100755
--- a/schema/spacewalk/spacewalk-schema-upgrade
+++ b/schema/spacewalk/spacewalk-schema-upgrade
@@ -141,7 +141,7 @@ my $start = $start_schema_norm;
my $in = <<EOF;
update rhnVersionInfo
set label = 'schema-from-' || to_char(created,
'YYYYMMDD-HH24MISS'),
- modified = sysdate
+ modified = current_timestamp
where label = 'schema';
commit;
EOF
@@ -211,7 +211,7 @@ insert into rhnVersionInfo
( label, name_id, evr_id, created, modified )
values ('schema', lookup_package_name('$my_schema_name'),
lookup_evr(null, '$my_schema_version' ,
'$my_schema_release' ),
- sysdate, sysdate );
+ current_timestamp, current_timestamp );
commit;
EOF
Show replies by date