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:[EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> To: "scott" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > 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" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > 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:[EMAIL PROTECTED] > > Sent: Thursday, April 08, 2004 3:44 PM > > To: [EMAIL PROTECTED] > > 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 [EMAIL PROTECTED]) > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 7: don't forget to increase your free space map settings ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
