• Bruce Momjian's avatar
    The following patch finishes primary key support. Previously, when · c91dbcc5
    Bruce Momjian authored
    a field was labelled as a primary key, the system automatically
    created a unique index on the field.  This patch extends it so
    that the index has the indisprimary field set.  You can pull a list
    of primary keys with the followiing select.
    
    SELECT pg_class.relname, pg_attribute.attname
        FROM pg_class, pg_attribute, pg_index
        WHERE pg_class.oid = pg_attribute.attrelid AND
            pg_class.oid = pg_index.indrelid AND
            pg_index.indkey[0] = pg_attribute.attnum AND
            pg_index.indisunique = 't';
    
    There is nothing in this patch that modifies the template database to
    set the indisprimary attribute for system tables.  Should they be
    changed or should we only be concerned with user tables?
    
    D'Arcy
    c91dbcc5
bootparse.y 5.77 KB