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
|