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

Attachment: signature.asc
Description: Digital signature

Reply via email to