web/modules/rhn/RHN/DB/Server.pm | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit a4d1219d7294fe142c74182f29d67c323f3753ab
Author: Pierre Casenove <pcasenove(a)gmail.com>
Date: Wed Jul 11 16:20:49 2012 +0000
Fix ISE on pgsql: Error message: RHN::Exception: DBD::Pg::st execute failed: ERROR:
syntax error at or near "NAME" at character 40
diff --git a/web/modules/rhn/RHN/DB/Server.pm b/web/modules/rhn/RHN/DB/Server.pm
index 8d466ad..235c483 100644
--- a/web/modules/rhn/RHN/DB/Server.pm
+++ b/web/modules/rhn/RHN/DB/Server.pm
@@ -848,7 +848,7 @@ sub server_event_delta_action {
my $dbh = RHN::DB->connect;
my $sth = $dbh->prepare(<<EOS);
-SELECT rTO.label AS OPERATION, PN.name NAME, PN.name || '-' ||
PE.evr.as_vre_simple() AS NVRE
+SELECT rTO.label AS OPERATION, PN.name AS NAME, PN.name || '-' ||
evr_t_as_vre_simple(PE.evr) AS NVRE
FROM rhnPackageName PN,
rhnPackageEVR PE,
rhnTransactionOperation rTO,