Default values not working

From: "Bryan White" <bryan(at)arcamax(dot)com>
To: <pgsql-general(at)postgreSQL(dot)org>
Subject: Default values not working
Date: 1999-06-30 13:29:08
Message-ID: 002901bec2fc$8839f780$22d260d1@arcamax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-interfaces

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ross J. Reedstrom 1999-06-30 15:17:32 Re: [GENERAL] Postgres Upsizing Tool for MSAccess 97
Previous Message Michael Andreasen 1999-06-30 09:52:17 SELECT ... EXCEPT SELECT ... takes too long! Why?

Browse pgsql-interfaces by date

  From Date Subject
Next Message Thomas Lockhart 1999-06-30 13:56:53 Re: [INTERFACES] Problem with regression test
Previous Message José Soares 1999-06-30 12:31:38 Re: [INTERFACES] ODBC: OID column in views