Login
[x]
Log in using an account from:
Fedora Account System
Red Hat Associate
Red Hat Customer
Or login using a Red Hat Bugzilla account
Forgot Password
Login:
Hide Forgot
Create an Account
Red Hat Bugzilla – Attachment 577018 Details for
Bug 811646
Cannot register KVM guest on host with rhn-virtualization-host installed with postgresql backend
[?]
New
Simple Search
Advanced Search
My Links
Browse
Requests
Reports
Current State
Search
Tabular reports
Graphical reports
Duplicates
Other Reports
User Changes
Plotly Reports
Bug Status
Bug Severity
Non-Defaults
|
Product Dashboard
Help
Page Help!
Bug Writing Guidelines
What's new
Browser Support Policy
5.0.4.rh83 Release notes
FAQ
Guides index
User guide
Web Services
Contact
Legal
This site requires JavaScript to be enabled to function correctly, please enable it.
[patch]
Fix to 'unknown column free_slots' postgresql bug
postgres_free_slots_fix.patch (text/plain), 885 bytes, created by
James Hogarth
on 2012-04-12 09:34:29 UTC
(
hide
)
Description:
Fix to 'unknown column free_slots' postgresql bug
Filename:
MIME Type:
Creator:
James Hogarth
Created:
2012-04-12 09:34:29 UTC
Size:
885 bytes
patch
obsolete
>diff --git a/schema/spacewalk/postgres/packages/rhn_entitlements.pkb b/schema/spacewalk/postgres/packages/rhn_entitlements.pkb >index ca87089..e496bfb 100644 >--- a/schema/spacewalk/postgres/packages/rhn_entitlements.pkb >+++ b/schema/spacewalk/postgres/packages/rhn_entitlements.pkb >@@ -598,6 +598,7 @@ as $$ > current_members_calc numeric; > sg_id numeric; > is_virt numeric := 0; >+ free_slots numeric := 0; > begin > select 1 into is_virt > from rhnServerEntitlementView >@@ -612,6 +613,11 @@ as $$ > into org_id_val > from rhnServer > where id = server_id_in; >+ >+ select select sfc.max_members - sfc.current_members >+ into free_slots >+ from rhnServerFveCapable sfc >+ where sfc.server_id = server_id_in; > > -- deal w/ channel entitlements first ... > for family in families loop
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=577018">View the attachment on a separate page</a>.</b>
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
Attachments on
bug 811646
:
576812
|
576813
|
577018
|
577020
|
577396
|
578655