"scott.marlowe" <scott.marlowe@ihs.com> writes:
> S is the schema, so it would appear they do mean that constraints are
> "contained" so to speak by a schema.
Right. In SQL92 constraint names have to be unique within the table's
schema. Postgres allows two different tables to have similarly-named
constraints, and that difference is the root of the issue.
regards, tom lane