pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Problem inserting data into 7.4.2 table
4+ messages / 2 participants
[nested] [flat]

* Problem inserting data into 7.4.2 table
@ 2004-04-08 22:44 Chris White (cjwhite) <cjwhite@cisco.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Chris White (cjwhite) @ 2004-04-08 22:44 UTC (permalink / raw)
  To: pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Problem inserting data into 7.4.2 table
@ 2004-04-08 23:35 Gregory S. Williamson <gsw@globexplorer.com>
  2004-04-08 23:57 ` Re: Problem inserting data into 7.4.2 table Chris White (cjwhite) <cjwhite@cisco.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Gregory S. Williamson @ 2004-04-08 23:35 UTC (permalink / raw)
  To: cjwhite@cisco.com; pgsql-admin

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)



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Problem inserting data into 7.4.2 table
  2004-04-08 23:35 Re: Problem inserting data into 7.4.2 table Gregory S. Williamson <gsw@globexplorer.com>
@ 2004-04-08 23:57 ` Chris White (cjwhite) <cjwhite@cisco.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Chris White (cjwhite) @ 2004-04-08 23:57 UTC (permalink / raw)
  To: 'Gregory S. Williamson' <gsw@globexplorer.com>; pgsql-admin

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)




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* FW: Problem inserting data into 7.4.2 table
@ 2004-04-09 00:35 Gregory S. Williamson <gsw@globexplorer.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Gregory S. Williamson @ 2004-04-09 00:35 UTC (permalink / raw)
  To: 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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2004-04-09 00:35 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-04-08 22:44 Problem inserting data into 7.4.2 table Chris White (cjwhite) <cjwhite@cisco.com>
2004-04-08 23:35 Re: Problem inserting data into 7.4.2 table Gregory S. Williamson <gsw@globexplorer.com>
2004-04-08 23:57 ` Chris White (cjwhite) <cjwhite@cisco.com>
2004-04-09 00:35 FW: Problem inserting data into 7.4.2 table Gregory S. Williamson <gsw@globexplorer.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox