[Spacewalk-list] Can't Create New Channel

[AJ Kertis]

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 <jpazdziora at redhat.com> 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
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20130807/cec3fbbd/attachment.htm>