• Tom Lane's avatar
    Fix errors in key_column_usage.position_in_unique_constraint column recently · 33556af7
    Tom Lane authored
    added to information_schema (per a SQL2003 addition).  The original coding
    failed if a referenced column participated in more than one pg_constraint
    entry.  Also, it did not work if an FK relied directly on a unique index
    without any constraint syntactic sugar --- this case is outside the SQL spec,
    but PG has always supported it, so it's reasonable for our information_schema
    to handle it too.  Per bug#2750 from Stephen Haberman.
    
    Although this patch changes the initial catalog contents, I didn't force
    initdb.  Any beta3 testers who need the fix can install it via CREATE OR
    REPLACE VIEW, so forcing them to initdb seems an unnecessary imposition.
    33556af7
information_schema.sql 80.7 KB