Why isn't sqlalchemy's default column value working [duplicate]

Question

I am using Postgresql 9.1 and SQLAlchemy 0.9.

The problem is, 'default=10' doesn't work.

My Code:

conn_str = 'postgresql://test:pass@localhost/test'
engine = create_engine(conn_str)
metadata = MetaData(bind=engine)

cols=[]
cols += [Column('Name', VARCHAR(20), primary_key=True, nullable=False)]
cols += [Column('age', INT, default=10, nullable=False )]
Table('t1', metadata, *cols)
metadata.create_all(engine)

psql:

test=> \dS t1
            Table "public.t1"
Column |         Type          | Modifiers
--------+-----------------------+-----------
Name   | character varying(20) | not null
age    | integer               | not null
Indexes:
    "t1_pkey" PRIMARY KEY, btree ("Name")

I tried with an SQL statement directly and it should look like:

test=> \dS t2
              Table "public.t2"
 Column |         Type          | Modifiers
--------+-----------------------+------------
 Name   | character varying(10) | not null
 age    | integer               | default 10
Indexes:
    "t2_pkey" PRIMARY KEY, btree ("Name")

What am I doing wrong?

I have the same issues. All default values are being ignored. — Alain1405
– Alain1405, Commented Apr 13, 2016 at 13:32

Chockomonkey · Accepted Answer · 2019-02-08 22:20:59Z

39

instead of using default, use server_default... fixed the problem for me https://docs.sqlalchemy.org/en/latest/core/defaults.html?highlight=schema%20column#sqlalchemy.schema.ColumnDefault

edited Feb 8, 2019 at 22:20

Chockomonkey

4,1457 gold badges44 silver badges58 bronze badges

answered Dec 18, 2013 at 2:28

tbischel

6,50712 gold badges54 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Why isn't sqlalchemy's default column value working [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related