FW: Problem inserting data into 7.4.2 table
От | Gregory S. Williamson |
---|---|
Тема | FW: Problem inserting data into 7.4.2 table |
Дата | |
Msg-id | 71E37EF6B7DCC1499CEA0316A2568328DC9BA2@loki.wc.globexplorer.net обсуждение исходный текст |
Список | pgsql-admin |
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@QNET.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@globexplorer.com> To: "scott" <scott@QNET.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@QNET.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@globexplorer.com> > To: <cjwhite@cisco.com>; <pgsql-admin@postgresql.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@cisco.com] > > Sent: Thursday, April 08, 2004 3:44 PM > > To: pgsql-admin@postgresql.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@postgresql.org) > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 7: don't forget to increase your free space map settings
В списке pgsql-admin по дате отправления: