Hi! Thanks for your very prompt answer. Unluckily, my mails were a little bit unprecise:
So, I wondered why the following happened: prop = get_mapper(Participation).get_property('remark') c=prop.columns[0] c Column(u'remark', PGText(length=None, convert_unicode=False, assert_unicode=None), table=<%(188392684 participation)s>, nullable=False) gives me a column c.server_default no server default c2=iter(c.base_columns).next() c2 Column(u'remark', PGText(length=None, convert_unicode=False, assert_unicode=None), table=<participation>, nullable=False, server_default=DefaultClause(<sqlalchemy.sql.expression._TextClause object at 0xb3b17cc>, for_update=False)) c2.server_default DefaultClause(<sqlalchemy.sql.expression._TextClause object at 0xb3b17cc>, for_update=False) Somehow in base_columns the server default is detected. It is a little bit unclear to me, why the server_default is detected in c2, but not in c. In fact I used the base_columns now as a workaround for RUM, but it feels quite hacky. By the way, I simply *love* SA. Moreover, I am very impressed, that (while of course unable to use them) my postgresql db contains partial indices. That's a very good sign for the reflection code. Cheers, Michael Am 15.04.2010 um 15:19 schrieb Michael Bayer: > > On Apr 15, 2010, at 7:26 AM, Michael Brickenstein wrote: > >> >> >> On 15 Apr., 13:03, Michael Brickenstein <brickenst...@mfo.de> wrote: >>> Sorry, forgot to mention, I had the same behaviour with SA 0.5.6 and >>> 0.5.8. >>> Cheers, >> >>>> In former times, I used >>>> prop.server_default to find out, that there is an default of ''. >> Sorry, that's wrong it has always been the columns[0], that I have to >> inspect. >> Nevertheless, the question for an official way remains, so far the >> situation is the following: >> c.server_default >> -> None >> >> c2=iter(c.base_columns).next() >> -> DefaultClause(<sqlalchemy.sql.expression._TextClause object at >> 0xa2507ac>, for_update=False) >> >> Is that a bug or a feature? > > > server_default is where we put whatever server side defaults were detected > during reflection. They reflect as a sqlalchemy.schema.DefaultClause, "arg" > is a TextClause representing what was received, and calling str() on that > gives you the ultimate value. The TextClause is so that we can > differentiate it from a literal python-defined value that would require > quoting. > > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.