schema/spacewalk/spacewalk-schema-upgrade | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
New commits:
commit a2a07f380a7f334dd161657444a5c2bef5a0d3a2
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Thu Jan 20 18:19:30 2011 +0100
Fixing PE.evr.as_vre_simple() issue on PostgreSQL.
Addressing
psql:<stdin>:5: ERROR: cross-database references are not implemented:
pe.evr.as_vre_simple
diff --git a/schema/spacewalk/spacewalk-schema-upgrade
b/schema/spacewalk/spacewalk-schema-upgrade
index 3532f11..0a78b3b 100755
--- a/schema/spacewalk/spacewalk-schema-upgrade
+++ b/schema/spacewalk/spacewalk-schema-upgrade
@@ -30,7 +30,7 @@ if ($test ne '123') {
}
my $schema_version = run_query(<<EOF);
- select rhnPackageName.name || '-' || PE.evr.as_vre_simple()
+ select rhnPackageName.name || '-' || evr_t_as_vre_simple(PE.evr)
from rhnVersionInfo, rhnPackageName, rhnPackageEVR PE
where rhnVersionInfo.label = 'schema'
and rhnVersionInfo.name_id = rhnPackageName.id
@@ -258,7 +258,7 @@ if ($?) {
}
my $new_schema_version = run_query(<<EOF);
- select rhnPackageName.name || '-' || PE.evr.as_vre_simple()
+ select rhnPackageName.name || '-' || evr_t_as_vre_simple(PE.evr)
from rhnVersionInfo, rhnPackageName, rhnPackageEVR PE
where rhnVersionInfo.label = 'schema'
and rhnVersionInfo.name_id = rhnPackageName.id
commit f1c4c71057a8d9042f1375c8f879d3da1778632d
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Thu Jan 20 18:16:41 2011 +0100
Concatenate strings.
Addressing
psql:<stdin>:1: ERROR: operator does not exist: integer || integer
LINE 1: select 1 || 2 || 3 as testing from dual;
^
HINT: No operator matches the given name and argument type(s). You might need to add
explicit type casts.
diff --git a/schema/spacewalk/spacewalk-schema-upgrade
b/schema/spacewalk/spacewalk-schema-upgrade
index dde099b..3532f11 100755
--- a/schema/spacewalk/spacewalk-schema-upgrade
+++ b/schema/spacewalk/spacewalk-schema-upgrade
@@ -21,7 +21,7 @@ if (not defined $options{db_backend}) {
die "Config file [$config_file] does not seem to have database backend info
(db_backend) set.\n";
}
-my $test = run_query("select 1 || 2 || 3 as testing from dual;");
+my $test = run_query("select '1' || '2' || '3' as testing
from dual;");
if (not defined $test) {
die "Connect to database was not successful.\n";
}
Show replies by date