Sorry for getting back late to this thread. I was able to restore the oracle dump again and this time it seemed to work fine. The task scheduler is running again and I can create new channels like before. It took 3 tries to get the dump to work perfectly but it seems the postgresql database is now working like expected.
On Thu, Aug 1, 2013 at 4:23 AM, Jan Pazdziora <[email protected]> wrote: > On Tue, Jul 30, 2013 at 03:53:30AM -0400, Tomas Lestach wrote: > > I would say your schema isn't in a very good shape. > > > > last_modified column of the rhnChannel table has a 'default' set to > current_timestamp: > > > > last_modified timestamp with local time zone > > DEFAULT (current_timestamp) NOT NULL, > > > > so, you should not fail on last_modified being null. > > That's not necessarily true. If the INSERT/UPDATE command specifically > sets the column to the NULL value, the DEFAULT will not be used. > > -- > Jan Pazdziora > Principal Software Engineer, Identity Management Engineering, Red Hat > > _______________________________________________ > Spacewalk-list mailing list > [email protected] > https://www.redhat.com/mailman/listinfo/spacewalk-list >
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
