Bug 1215151 - 021-rhnServerNetwork-trigger.sql.oracle: IF EXISTS isn't Oracle syntax
Summary: 021-rhnServerNetwork-trigger.sql.oracle: IF EXISTS isn't Oracle syntax
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Spacewalk
Classification: Community
Component: Installation
Version: 2.3
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Grant Gainey
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: space27
TreeView+ depends on / blocked
 
Reported: 2015-04-24 12:28 UTC by Grant Gainey
Modified: 2017-09-28 18:10 UTC (History)
1 user (show)

Fixed In Version: spacewalk-schema-2.4.4-1 , spacewalk-schema-2.3.44-1
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2015-04-27 18:04:58 UTC
Embargoed:

Attachments (Terms of Use)

Description Grant Gainey 2015-04-24 12:28:00 UTC 
"IF EXISTS does not exist on oracle. This fails the upgrade from 2.2 to 2.3. Removing IF EXISTS part does work and lets upgrade run smoothly."

See https://github.com/spacewalkproject/spacewalk/pull/250
Comment 1 Grant Gainey 2015-04-24 12:29:53 UTC 
NOTE: needs to be fixed and released to 2.3, as it blocks installation with external-oracle
Comment 2 Grant Gainey 2015-04-27 14:32:46 UTC 
spacewalk.github commit ebc6c3b43690242bd512611ea456013739339244
Comment 3 Grant Gainey 2015-04-27 14:35:36 UTC 
spacewalk.github SPACEWALK-2.3 f24c98274c87cf30796eb01a57e19b5d0f0f3bdc
Comment 4 Grant Gainey 2015-04-27 18:04:58 UTC 
Updated 021*postgresql to have sha1 of oracle change

master:        052c514818e76ad214867793fe961fb368dae060
SPACEWALK-2.3: 0955ef5a2e487d5c75601fedcca61d946f0508af
Comment 5 Eric Herget 2017-09-28 18:10:06 UTC 
This BZ closed some time during 2.5, 2.6 or 2.7.  Adding to 2.7 tracking bug.
Note You need to log in before you can comment on or make changes to this bug.