Erwin Brandstetter wrote:
- Trying to add a comment to UNIQUE CONSTRAINT fails altogether.
Actually, it doesn't fail to write. It just doesn't show up anywhere in pgadmin afterwards.
psql doesn't seem to have a meta-command to retrieve comments on constraints. But checking by OID with "obj_description" reveals it:
SELECT obj_description(2666870, 'pg_constraint'); Regards Erwin ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match