Skip site navigation (1) Skip section navigation (2)

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

From: Alex Pilosov <alex(at)pilosoft(dot)com>
To: "Tom(dot)Bakken" <Tom(dot)Bakken(at)tx(dot)usda(dot)gov>
Cc: Postgres general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Data migration problems with Upgrade from Version 6.5.2 to 7.1.2
Date: 2001-06-27 17:53:17
Message-ID: Pine.BSO.4.10.10106271352400.598-100000@spider.pilosoft.com (view raw or flat)
Thread:
Lists: pgsql-general
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
> 
> 


In response to

Responses

pgsql-general by date

Next:From: Gregory WoodDate: 2001-06-27 19:30:23
Subject: Re: Data migration problems with Upgrade from Version 6.5.2 to 7.1.2
Previous:From: Bruce MomjianDate: 2001-06-27 17:52:40
Subject: Re: SHMMAX value

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group