[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