[rt-users] Problem with make install

[Jesse]

gimme a bit to try getting postgres up....


On Fri, Mar 02, 2001 at 01:15:19PM -0500, Don Lafontaine wrote:
> 
> I still haven't been able to install rt2 yet.  I have installed Postgres
> 7.1 and I have the latest RT (Downloaded yesterday).
> 
> Here's the error I get with make install:
> 
> Problem with statement:
>  CREATE TABLE Users (
>   id serial NOT NULL  ,
>   Name varchar(120) NOT NULL  ,
>   Password varchar(40)   ,
>   Comments TEXT   ,
>   Signature TEXT   ,
>   EmailAddress varchar(120)   ,
>   FreeformContactInfo TEXT   ,
>   Organization varchar(200)   ,
>   Privileged integer   ,
>   RealName varchar(120)   ,
>   Nickname varchar(16)   ,
>   Lang varchar(16)   ,
>   EmailEncoding varchar(16)   ,
>   WebEncoding varchar(16)   ,
>   ExternalContactInfoId varchar(100)   ,
>   ContactInfoSystem varchar(30)   ,
>   ExternalAuthId varchar(100)   ,
>   AuthSystem varchar(30)   ,
>   Gecos varchar(16)   ,
>   HomePhone varchar(30)   ,
>   WorkPhone varchar(30)   ,
>   MobilePhone varchar(30)   ,
>   PagerPhone varchar(30)   ,
>   Address1 varchar(200)   ,
>   Address2 varchar(200)   ,
>   City varchar(100)   ,
>   State varchar(100)   ,
>   Zip varchar(16)   ,
>   Country varchar(50)   ,
>   Creator integer   ,
>   Created timestamp   ,
>   LastUpdatedBy integer   ,
>   LastUpdated timestamp   ,
>   Disabled bool NOT NULL DEFAULT 0 
> )
> 
> ERROR:  Attribute 'disabled' is of type 'bool' but default expression is
> of type 'int4'
> 	You will need to rewrite or cast the expression
> Database handle destroyed without explicit disconnect, <STDIN> chunk 2.
> 
> 
> Any clues?
> 
> Thanks folks!
> Don.
> 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 

-- 
jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com 
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

...realized that the entire structure of the net could be changed to be made 
more efficient, elegant, and spontaneously make more money for everyone 
involved. It's a marvelously simple diagram, but this form doesn't have a way 
for me to draw it.  It'll wait. 				-Adam Hirsch