[Spacewalk-list] SQL errors after upgrade 1.2 -> 1.3

[Michael Mraka]

Nat N wrote:
% Hello.
% 
% After (successfully) upgrading from 1.2 to 1.3. I am now getting the
% following alerts being sent to me
% 
% I am using centos 5.5 (with a postgres backend)
% 
% Any ideas? the SQL generated looks OK to me so I am not sure...
% 
% Thanks!!
% Nathan
% 
...
% SQL Error generated: ('syntax error at or near "with id" at character
% 143\n', 0, '\n    select sa.action_id, sa.status\n      from
% rhnServerAction sa,\n         (\n          select id\n            from
% rhnAction\n           start with id = %(action_id)s\n
% connect by prior id = prerequisite\n         ) a\n     where
% sa.server_id = %(server_id)s\n       and sa.action_id = a.id\n')

Hi Nathan,

This error has been fixed in nightly repo (package
spacewalk-backend-1.4.20-1). Unfortunately the change is a bit complex
(commits f752cc6680932cf1245f3260347367030b49e8ca to
25263f4c806c5eda910b4b5f26eb4030a92118df) so at the moment we are not
planning to backport it.

Regards,

--
Michael Mráka
Satellite Engineering, Red Hat