diff options
author | Mike Bayer <mike_mp@zzzcomputing.com> | 2014-09-20 17:00:21 -0400 |
---|---|---|
committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2014-09-20 17:23:00 -0400 |
commit | ff74edfc7e1dab3f6e19c546eb956fbd0bae30d8 (patch) | |
tree | 4e5de78a5c3c7ea94a6b11c70cb10826d0405645 /docs | |
parent | 75652fe132913aea255e55d89b29c393283cdd06 (diff) | |
download | alembic-ff74edfc7e1dab3f6e19c546eb956fbd0bae30d8.tar.gz |
- Added a routine by which the Postgresql Alembic dialect inspects
the server default of INTEGER/BIGINT columns as they are reflected
during autogenerate for the pattern ``nextval(<name>...)`` containing
a potential sequence name, then queries ``pg_catalog`` to see if this
sequence is "owned" by the column being reflected; if so, it assumes
this is a SERIAL or BIGSERIAL column and the server default is
omitted from the column reflection as well as any kind of
server_default comparison or rendering, along with an INFO message
in the logs indicating this has taken place. This allows SERIAL/BIGSERIAL
columns to keep the SEQUENCE from being unnecessarily present within
the autogenerate operation.
fixes #73
Diffstat (limited to 'docs')
-rw-r--r-- | docs/build/changelog.rst | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/docs/build/changelog.rst b/docs/build/changelog.rst index a2c0239..34e5e99 100644 --- a/docs/build/changelog.rst +++ b/docs/build/changelog.rst @@ -6,6 +6,22 @@ Changelog :version: 0.7.0 .. change:: + :tags: bug, autogenerate, postgresql + :tickets: 73 + + Added a routine by which the Postgresql Alembic dialect inspects + the server default of INTEGER/BIGINT columns as they are reflected + during autogenerate for the pattern ``nextval(<name>...)`` containing + a potential sequence name, then queries ``pg_catalog`` to see if this + sequence is "owned" by the column being reflected; if so, it assumes + this is a SERIAL or BIGSERIAL column and the server default is + omitted from the column reflection as well as any kind of + server_default comparison or rendering, along with an INFO message + in the logs indicating this has taken place. This allows SERIAL/BIGSERIAL + columns to keep the SEQUENCE from being unnecessarily present within + the autogenerate operation. + + .. change:: :tags: bug, autogenerate :tickets: 197, 64, 196 |