Hi Jan, the patch solved my problem.
Thanks for your help. Regards, Silvio -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jan Pazdziora Sent: Tuesday, July 12, 2011 4:10 PM To: [email protected] Subject: Re: [Spacewalk-list] Problems with db import from oracle to postgres On Tue, Jul 12, 2011 at 02:01:19PM +0000, [email protected] wrote: > Hi, > > fgrep -B1 rhnpackagerepodata spacewalk-oracle.dmp ... > -- Types for rhnpackagerepodata: DOUBLE PRECISION BLOB BLOB BLOB DATE > DATE Can you apply the following patch to your spacewalk-dump-schema and dump and import the schema again, to see if it addresses the problem for you? diff --git a/utils/spacewalk-dump-schema b/utils/spacewalk-dump-schema index e391111..0068ed4 100755 --- a/utils/spacewalk-dump-schema +++ b/utils/spacewalk-dump-schema @@ -115,7 +115,7 @@ sub process_table { if (ref $row->[$i] and ref $row->[$i] eq 'ARRAY') { # user types no warnings 'uninitialized'; $row->[$i] = "(@{[ join ',', @{$row->[$i]} ]})"; - } elsif ($types[$i] eq 'unknown') { # blobs + } elsif ($types[$i] eq 'unknown' or $types[$i] eq 'BLOB') { # blobs $row->[$i] =~ s!(.)! sprintf "\\\\%03o", ord($1) !seg; } else { $row->[$i] =~ s!([\x00-\x1f\x5c])! sprintf "\\x%02x", ord($1) !seg; -- Jan Pazdziora Principal Software Engineer, Satellite Engineering, Red Hat _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list ---------------------------------------------------------------- Please note: This e-mail may contain confidential information intended solely for the addressee. If you have received this e-mail in error, please do not disclose it to anyone, notify the sender promptly, and delete the message from your system. Thank you. _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
