Default values not working - Mailing list pgsql-general

From Bryan White
Subject Default values not working
Date
Msg-id 002901bec2fc$8839f780$22d260d1@arcamax.com
Whole thread Raw
Responses large objects  (Lauri Posti <lauri@peak.edu.ee>)
List pgsql-general
If I add a field to a colum using:
    alter table mytable add column myint int not null default 0;
The default value does not seem to make it into the data dictionary.

This is using Postgres 6.5.

Is there is way to manually poke a default value into the data dictionary?

Bryan White
ArcaMax Inc.
Yorktown VA
www.arcamax.com


pgsql-general by date:

Previous
From: "Stephen Boyle"
Date:
Subject: Postgres Upsizing Tool for MSAccess 97
Next
From: ralli@poboxes.com
Date:
Subject: (no subject)