I don't know offhand since I didn't write that code.  However if you google for 
"pg_get_expr 128", there's a ton of other hits illustrating this same 
expression being used elsewhere.   I believe the statement itself comes from 
Postgresql itself ultimately, if you look at this answer: 
http://stackoverflow.com/a/5371745/34549

Can you try removing the substring() and seeing if this function in fact 
returns the whole default as you're looking for?






On Oct 16, 2013, at 1:13 AM, 문성원 <[email protected]> wrote:

> in current version, server_default is truncated if it is longer than 128.
> 
> https://bitbucket.org/zzzeek/sqlalchemy/src/a5dc173ea6735c2b0877c771d2cb0693ac8dca82/lib/sqlalchemy/dialects/postgresql/base.py?at=master#cl-1687
> 
> while it is a minor problem usually, but it bothers some tool using table's 
> metadata.(ex. alembic)
> 
> any other dialect doesn't seem have such restriction.
> 
> -- 
> You received this message because you are subscribed to the Google Groups 
> "sqlalchemy" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/groups/opt_out.

Attachment: signature.asc
Description: Message signed with OpenPGP using GPGMail

Reply via email to