Reverse Engeneered SQL for DEFAULT

From: "Luc ROLLAND" <luc(at)rolland-fr(dot)com>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Reverse Engeneered SQL for DEFAULT
Date: 2004-02-21 09:48:45
Message-ID: 000b01c3f85f$e6383250$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 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

Browse pgadmin-support by date

  From Date Subject
Next Message Luc ROLLAND 2004-02-21 10:00:57 Reverse engeenered SQL for COMMENT ON CHECK
Previous Message Dave Page 2004-02-20 19:35:30 Re: BUG: spaces in passwords