Hi all, i just want to verify my observation that SA (svn trunk) includes a PrimaryKeyConstraint for every table even if there is no PK constraint in the database. Is this correct?
--- snip --- $ psql wp_sw_20091030 psql (8.4.1) SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256) Type "help" for help. wp_sw_20091030=# \d externallinks Table "public.externallinks" Column | Type | Modifiers ----------+-------------------+-------------------- el_from | integer | not null default 0 el_to | character varying | not null el_index | character varying | not null wp_sw_20091030=# --- >>> eng = >>> create_engine('postgresql+psycopg2://USER:passw...@localhost/wp_sw_20091030') >>> met = MetaData(bind=eng) >>> met.reflect() >>> el_t = met.tables['externallinks'] >>> el_t.constraints set([PrimaryKeyConstraint()]) >>> pk_con = el_t.primary_key >>> pk_con.name >>> pk_con.info {} >>> pk_con.columns.keys() [] --- snip --- thanks Wolodja
signature.asc
Description: Digital signature