[Spacewalk-list] Can't Create New Channel

Jan Pazdziora jpazdziora at redhat.com
Thu Aug 1 08:23:44 UTC 2013


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




More information about the Spacewalk-list mailing list