• Tom Lane's avatar
    For foreign keys, check REFERENCES privilege only on the referenced table. · 64d4da51
    Tom Lane authored
    We were requiring that the user have REFERENCES permission on both the
    referenced and referencing tables --- but this doesn't seem to have any
    support in the SQL standard, which says only that you need REFERENCES
    permission on the referenced table.  And ALTER TABLE ADD FOREIGN KEY has
    already checked that you own the referencing table, so the check could
    only fail if a table owner has revoked his own REFERENCES permission.
    Moreover, the symmetric interpretation of this permission is unintuitive
    and confusing, as per complaint from Paul Jungwirth.  So let's drop the
    referencing-side check.
    
    In passing, do a bit of wordsmithing on the GRANT reference page so that
    all the privilege types are described in similar fashion.
    
    Discussion: https://postgr.es/m/8940.1490906755@sss.pgh.pa.us
    64d4da51
create_table.sgml 70.7 KB