I'm not sure I understand what you're looking for...you want the column to
remain NULL after an insert?

Then take off the default from the column definition and make it a datetime
field instead of a timestamp.


On Jan 10, 2008 9:15 PM, deanH <[EMAIL PROTECTED]> wrote:

>
> Hello,
>
> I am having a problem inserting an object into a MS SQL table that
> contains a timestamp field (now) that is generated automatically -
> sqlalchemy is defaulting this column to None and when it is generating
> the SQL insert.  Is there a way to configure the mapper so that it
> ignores specific columns?
>
> I looked at the related topic below, but that is resolved by using a
> sqlalchemy construct specific to primary keys, and i have not seen one
> that is designated for timestamps.
>
> http://groups.google.com/group/sqlalchemy/browse_thread/thread/749c55a835b7458/51b38f4b08d31d6f?lnk=gst&q=column+exclude#51b38f4b08d31d6f
>
> I am new to sqlalchemy so I may be going about this the wrong way, but
> my attempts at overriding with a reflected column were similarly
> unsuccessful.
>
> Column('now', MSTimeStamp, nullable=False)
>
> Any thoughts on how to exclude columns from generated inserts?
>
> cheers
> dean
>
> >
>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to