FW: Problem inserting data into 7.4.2 table

Sorry to harass the list, and Scott, again ... could someone please remove this guy before he loses all faith in computers ?

;-)

Greg W.

(ps sorry Scott - I don't have a clue as to how to remove you myself)

-----Original Message-----
From: scott [mailto:scott(at)QNET(dot)COM]
Sent: Thursday, April 08, 2004 5:29 PM
To: Gregory S. Williamson
Subject: Re: [ADMIN] Problem inserting data into 7.4.2 table

I am harrassed DAILY by about 20 of the guys in your "ADMIN" group, a group
which I NEVER signed up for or asked to be signed up for! And then you make
it sound so easy "just unsubscribe from the list". HOW? I have e-mailed the
operator but it appears I am still on the list. HOW do I get OFF this list?
Will YOU take me off the list? This whole thing really sucks! I NEVER asked
for any of this-

Scott

----- Original Message -----
From: "Gregory S. Williamson" <gsw(at)globexplorer(dot)com>
To: "scott" <scott(at)QNET(dot)COM>
Sent: Thursday, April 08, 2004 5:12 PM
Subject: RE: [ADMIN] Problem inserting data into 7.4.2 table

>
> Why do you do this ? He had a problem and I answered. You don't like it
sign off the list, moron dweeb.
>
>
> -----Original Message-----
> From: scott [mailto:scott(at)QNET(dot)COM]
> Sent: Thursday, April 08, 2004 4:58 PM
> To: Gregory S. Williamson
> Subject: Re: [ADMIN] Problem inserting data into 7.4.2 table
>
>
> DID YOU TRY FUCKING OFF?
>
> ----- Original Message -----
> From: "Gregory S. Williamson" <gsw(at)globexplorer(dot)com>
> To: <cjwhite(at)cisco(dot)com>; <pgsql-admin(at)postgresql(dot)org>
> Sent: Thursday, April 08, 2004 4:35 PM
> Subject: Re: [ADMIN] Problem inserting data into 7.4.2 table
>
>
> > I just tried the sql below on a 7.4 instance and it works fine.
> >
> > # insert into vm_mailbox
> > values('PERSONAL00000000000000000000000',0,null,10000,60,true,0,30,true,
> > 10,0,1081462504500);
> > INSERT 13985274 1
> >
> > Are you sure this is the offending data ?
> >
> > Greg Williamson
> > DBA
> > GlobeXplorer LLC
> >
> > -----Original Message-----
> > From: Chris White (cjwhite) [mailto:cjwhite(at)cisco(dot)com]
> > Sent: Thursday, April 08, 2004 3:44 PM
> > To: pgsql-admin(at)postgresql(dot)org
> > Subject: [ADMIN] Problem inserting data into 7.4.2 table
> >
> >
> > I have just upgraded to 7.4.2 from 7.2.1 and I am having problems
> > inserting data into a database table that worked just fine under 7.2.1.
> >
> > I have a table defined as follows:
> >
> > create table vm_mailbox
> > (
> > MailboxId varchar(64) not null,
> > MailboxType integer not null default 0,
> > Description varchar(64) ,
> > MailboxSize integer ,
> > MessageSize integer ,
> > Tutorial boolean not null default true,
> > TotalMessageTime integer ,
> > MessageExpiryTime integer ,
> > Enabled boolean not null default true,
> > GreetingType integer not null default 10,
> > OrphanedTime bigint not null default 0,
> > LastAccessed bigint ,
> > ZeroOutNumber varchar(32) ,
> > primary key (MailboxId)
> > );
> >
> > When I try to do the following insert into the table
> >
> > insert into vm_mailbox
> > values('PERSONAL00000000000000000000000',0,null,10000,60,true,0,30,true,
> > 10,0,1081462504500);
> >
> > I get the following error:
> >
> > ERROR: integer out of range
> >
> > What is the problem? Is it complaining about the value for LastAccessed?
> > According to the 7.2 User Guide a bigint can have a value between
> > -92223372036854775808 and 92223372036854775807.
> >
> > Chris White
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 7: don't forget to increase your free space map settings