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 D9CDBD1CA77 for ; Thu, 8 Apr 2004 20:57:18 -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 69152-04 for ; Thu, 8 Apr 2004 20:57:19 -0300 (ADT) Received: from sj-iport-4.cisco.com (sj-iport-4.cisco.com [171.68.10.86]) by svr1.postgresql.org (Postfix) with ESMTP id A9658D1C9FB for ; Thu, 8 Apr 2004 20:57:15 -0300 (ADT) Received: from cjwhitew2k02 (dhcp-128-107-151-119.cisco.com [128.107.151.119]) by sj-core-4.cisco.com (8.12.10/8.12.6) with ESMTP id i38NvGew021695; Thu, 8 Apr 2004 16:57:16 -0700 (PDT) Reply-To: From: "Chris White (cjwhite)" To: "'Gregory S. Williamson'" , Subject: Re: Problem inserting data into 7.4.2 table Date: Thu, 8 Apr 2004 16:57:16 -0700 Message-ID: <002001c41dc5$38946a70$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 In-reply-to: <71E37EF6B7DCC1499CEA0316A2568328DC9B9C@loki.wc.globexplorer.net> 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/168 X-Sequence-Number: 13141 Found out that Postgres was compiled with the wrong int64 option. Changed it to HAVE_LONG_LONG_INT64 and was able to insert data into the table -----Original Message----- From: Gregory S. Williamson [mailto:gsw@globexplorer.com] Sent: Thursday, April 08, 2004 4:35 PM To: cjwhite@cisco.com; pgsql-admin@postgresql.org 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)