Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: pgadmin 1.8.0 beta3 bug


  • From: Erwin Brandstetter <a9006241(at)unet(dot)univie(dot)ac(dot)at>
  • To: dpage(at)postgresql(dot)org
  • Cc: pgadmin-support(at)postgresql(dot)org
  • Subject: Re: pgadmin 1.8.0 beta3 bug
  • Date: Thu, 30 Aug 2007 23:17:23 +0200
  • Message-id: <46D733E3.2090204@unet.univie.ac.at> <text/plain>

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

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group