Web pgadmin.org
 Home 
 ·  ·  ·  ·  ·  ·  · 
Re: pgadmin 1.8.0 beta3 bug

Re: pgadmin 1.8.0 beta3 bug



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



Home | Main Index | Thread Index

top