pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedProblem 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>
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:57 Chris White (cjwhite) <cjwhite@cisco.com>
parent: Gregory S. Williamson <gsw@globexplorer.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