Re: Reverse engeenered SQL for COMMENT ON CHECK

Hi Luc,

Thanks for the bug report - this has now been fixed in CVs and will
appear in future releases.

Regards, Dave.

_____

From: Luc ROLLAND [mailto:luc(at)rolland-fr(dot)com]
Sent: 21 February 2004 10:01
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] Reverse engeenered SQL for COMMENT ON
CHECK


Hello !

First of all I use PgAdmin III and I like it !
Actually I use :
- PostgreSQL 7.4 v7.4.1 on Linux Mandrake 9.2 server,
- PgAdmin III v1.0.2 on an Windows XP SP1,
- All my systems and applications are French localized.

When on a onstraint with a comment, PgAdmin gives for ex. :
COMMENT ON CHECK public.adressesliv_nomliv IS 'Le nom est
obligatoire';
and I obtain
ERROR: syntax error at or near "CHECK" at character 12

I must use :
COMMENT ON CONSTRAINT adressesliv_nomliv ON public.adressesliv
IS 'Le nom est obligatoire';
the CHECK keyword is not recognized.

Best regards.

Luc ROLLAND