Reverse engeenered SQL for COMMENT ON CHECK

From: "Luc ROLLAND" <luc(at)rolland-fr(dot)com>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Reverse engeenered SQL for COMMENT ON CHECK
Date: 2004-02-21 10:00:57
Message-ID: 002d01c3f861$9bdddaf0$0100a8c0@lrp42600
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Browse pgadmin-support by date

  From Date Subject
Next Message Luc ROLLAND 2004-02-21 10:20:59 PgAdmin hangs on search upward
Previous Message Luc ROLLAND 2004-02-21 09:48:45 Reverse Engeneered SQL for DEFAULT