Re: Reverse engeenered SQL for COMMENT ON CHECK

---

From: Luc ROLLAND [mailto:luc@rolland-fr.com]
Sent: 21 February 2004 10:01
To: pgadmin-support@postgresql.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