Re: Data migration problems with Upgrade from Version 6.5.2 to 7.1.2

On Wed, 27 Jun 2001, Tom.Bakken wrote:

>
> How should I specify my boolean fields? I have them set up as follows:
>
> column BOOLEAN DEFAULT 0
It must be DEFAULT 'f'.

>
> This setup works well with Access97/odbc boolean fields such as check
> boxes etc.
>
> This format is acceptable to postgres 6.5.2 and data copies in and out
Its not acceptable to postgres 7.x , as you found out..
> without errors.
>
> If anybody's already been down this road, I'd appreciate the benefit of
> your experiences.
> --
> Tom Bakken
> Information Resource Manager
> USDA, Rural Development
> 101 South Main, Suite 102
> Temple, TX 76501
>
> Phone: 254-742-9726 Fax: 254-742-9709
> Email: tom(dot)bakken(at)tx(dot)usda(dot)gov
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>
>