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 colum with a default spec, PgAdmin gives for ex. :
ALTER TABLE public.adressesliv ALTER COLUMN principaliv DEFAULT false;
and I obtain
ERROR: syntax error at or near "DEFAULT" at character 57
I must use :
ALTER TABLE public.adressesliv ALTER COLUMN principaliv SET DEFAULT false;
the SET keyword is absent.
Best regards.
Luc ROLLAND