On 10/18/2011 03:03 PM, Scott Worthington wrote: > Miroslav Suchy, > > Thank you for that tip to add that new constraint to a system using > 1.6-nightly. > > Where is the code for the "alter table rhnservernetwork add constraint > vn_rhnservernetwork_ip6addr" located? > > I thought it would be in a file in the subdirectory of > /etc/sysconfig/rhn/schema-upgrade/ for users upgrading from Spacewalk > 1.5 to 1.6, but it is not. > > So I searched for the constraint portion of the alter table you > mentioned above in other places... > > grep -R -i "check (ip6addr::text" /usr/share/spacewalk/* > grep -R -i "check (ip6addr::text" /usr/share/perl5/* > grep -R -i "check (ip6addr::text" /usr/lib/python2.6/site-packages/spacewalk/* > grep -R -i "check (ip6addr::text" /usr/share/rhn/* > > ...but found no reference to it. > > Would you mind letting me know where that change gets applied in the > upgrade/setup/fresh-install code?
In fresh-install it is located in postgres/end.sql and is dynamically created by create_varnull_constriants() function. But I forget that this is not called during upgrades. I will add it to upgrade script as well. -- Miroslav Suchy Red Hat Satellite Engineering _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
