Received: from arcamax.com (arcamax.com [209.96.210.66]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA13134 for ; Wed, 30 Jun 1999 09:29:10 -0400 (EDT) (envelope-from bryan@arcamax.com) Received: from bryan.arcamax.com (bryan [209.96.210.34]) by arcamax.com (8.8.7/8.8.7) with SMTP id JAA20836 for ; Wed, 30 Jun 1999 09:29:08 -0400 Message-ID: <002901bec2fc$8839f780$22d260d1@arcamax.com> From: "Bryan White" To: Subject: Default values not working Date: Wed, 30 Jun 1999 09:29:08 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2014.211 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211 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