X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 768F0D1B989 for ; Thu, 8 Apr 2004 19:44:12 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 45860-10 for ; Thu, 8 Apr 2004 19:44:13 -0300 (ADT) Received: from sj-iport-5.cisco.com (sj-iport-5.cisco.com [171.68.10.87]) by svr1.postgresql.org (Postfix) with ESMTP id 192BAD1B49F for ; Thu, 8 Apr 2004 19:44:10 -0300 (ADT) Received: from sj-core-3.cisco.com (171.68.223.137) by sj-iport-5.cisco.com with ESMTP; 08 Apr 2004 15:45:13 -0700 Received: from cjwhitew2k02 (dhcp-128-107-151-119.cisco.com [128.107.151.119]) by sj-core-3.cisco.com (8.12.10/8.12.6) with ESMTP id i38MiBBB027689 for ; Thu, 8 Apr 2004 15:44:11 -0700 (PDT) Reply-To: From: "Chris White (cjwhite)" To: Subject: Problem inserting data into 7.4.2 table Date: Thu, 8 Apr 2004 15:44:10 -0700 Message-ID: <001601c41dbb$02ba2520$77976b80@amer.cisco.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.4024 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/166 X-Sequence-Number: 13139 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