[Spacewalk-list] DB question

[Miroslav Suchý]

On 04/27/2011 02:08 PM, Bo Maryniuk wrote:
> On 04/27/2011 10:59 AM, Miroslav Suchý wrote:
>> All frequently used pages/functions should work. But there are still
>> queries we did not migrate for sure.
> 
> Miroslav,
> is there a clear list of what is not working (for sure) on PostgreSQL
> and what still needs to be done, please? :)

No we do not have such list. We only have list of what is know to be
working:
https://fedorahosted.org/spacewalk/wiki/PostgreSQL#Functionalityknowntowork

Just for record, copy of our IRC chat:

[14:19] <msuchy-out> I would recommend you to start here:
https://fedorahosted.org/spacewalk/wiki/PostgreSQLPortingGuide
[14:19] <msuchy-out> which covers all problems you can encounter
[14:19] <msuchy-out> hopefully :)
[14:20] <msuchy-out> and git grep is your friend
[14:20] <msuchy-out> so git grep DECODE
[14:20] <msuchy-out> will give you files, which will couse ISE for sure.
[14:21] <msuchy-out> so rewrite it acording the howto
[14:21] <msuchy-out> and move to another item
[14:21] <msuchy-out> git grep '(+)'
[14:21] <msuchy-out> and so on ...
[14:23] <msuchy-out> after every fix, try it in nightly in both oracle
and postgresql to make sure you did not screw it and sent patch to
mailing list as soon as posible

-- 
Miroslav Suchy
Red Hat Satellite Engineering