Thread: 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
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.
COMMENT ON CONSTRAINT adressesliv_nomliv ON public.adressesliv IS 'Le nom est obligatoire';
the CHECK keyword is not recognized.
Best regards.
Luc ROLLAND
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@rolland-fr.com]
Sent: 21 February 2004 10:01
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Reverse engeenered SQL for COMMENT ON CHECKHello !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 12I 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