schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/003-assign_channel_entitlement.sql.postgresql | 7 +++++++ 1 file changed, 7 insertions(+)
New commits: commit 6f4fed1e542f8a794e6bff4b29a9d684f988b5bb Author: Simon Lukasik slukasik@redhat.com Date: Tue Aug 16 11:03:02 2011 +0200
Drop the old function, when creating a new one with different argumeters
Function gets not replaced by previous command, only overload.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/003-assign_channel_entitlement.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/003-assign_channel_entitlement.sql.postgresql index 66a5f1b..d7839d3 100644 --- a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/003-assign_channel_entitlement.sql.postgresql +++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/003-assign_channel_entitlement.sql.postgresql @@ -119,5 +119,12 @@ as $$ end$$ language plpgsql;
+drop function assign_channel_entitlement( + channel_family_label_in varchar, + from_org_id_in numeric, + to_org_id_in numeric, + quantity_in numeric + ); + -- restore the original setting update pg_settings set setting = overlay( setting placing '' from 1 for (length('rhn_entitlements')+1) ) where name = 'search_path';