java/code/src/com/redhat/rhn/common/db/datasource/xml/Channel_queries.xml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit e02c0ee726109530df4e0f38fc4770bb2ab2d11b
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Tue Oct 5 13:12:11 2010 +0200
Use current_timestamp instead of the Oracle-specific sysdate in request_repo_regen.
Addressing
org.postgresql.util.PSQLException: ERROR: column "sysdate" does not exist
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:347)
at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:651)
at
com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:139)
at
com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:454)
at
com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:431)
at
com.redhat.rhn.common.db.datasource.CachedStatement.executeUpdate(CachedStatement.java:269)
at
com.redhat.rhn.common.db.datasource.WriteMode.executeUpdate(WriteMode.java:33)
at
com.redhat.rhn.manager.channel.ChannelManager.queueChannelChange(ChannelManager.java:2592)
at
com.redhat.rhn.manager.channel.CreateChannelCommand.create(CreateChannelCommand.java:283)
diff --git a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Channel_queries.xml
b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Channel_queries.xml
index 06262e6..61e28fe 100644
--- a/java/code/src/com/redhat/rhn/common/db/datasource/xml/Channel_queries.xml
+++ b/java/code/src/com/redhat/rhn/common/db/datasource/xml/Channel_queries.xml
@@ -89,7 +89,7 @@ INSERT
INTO rhnRepoRegenQueue
(id, channel_label, client, reason, force, bypass_filters, next_action, created,
modified)
VALUES (null, -- the id is set by trigger on rhnRepoRegenQueue
- :label, :client, :reason, 'N', 'N', sysdate, sysdate, sysdate)
+ :label, :client, :reason, 'N', 'N', current_timestamp,
current_timestamp, current_timestamp)
</query>
</write-mode>
Show replies by date