From: | "McCormick, Bill" <BillMcCormick(at)Catholichealth(dot)net> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Help: Input Error Notice |
Date: | 2005-05-13 17:39:21 |
Message-ID: | ABEAB6B64DB04241B1CDBBE47447563E010BE26C@NITCMSX04.nitc.catholichealth.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I have been investigating this error message for several days now but am
unable to find anything useful--perhaps someone will be able to assist
me?
Thanks in advance for your assistance!
billmccormick(at)catholichealth(dot)net
The details:
In version 7.2, I have created a table:
Table "bulkdata"
Column | Type | Modifiers
--------------------+--------------------------+--------------
processedby | integer | default 0
recordstatus | integer | default 0
datetime | timestamp with time zone |
sourceaddress | inet |
sourceport | integer |
destinationaddress | inet |
destinationport | integer |
packetsize | integer |
direction | integer | default 0
category | integer | default 2000
associatedwith | integer | default 5000
I am running the output of tcpdump through an awk script to generate
insert statements for psql like: insert into bulkData values(0, 0,
'05/13/2005 11:29:20', '10.250.7.54', 1063, '10.255.64.90', 139, 1500,
1, 1000, 5035);
(/usr/sbin/tcpdump -i eth1 -nnttttvv udp or tcp 2>/dev/null | awk -f
/root/awkScript | /usr/bin/psql -f- traffic>/dev/null)
Periodically, I receive messages like: psql:<stdin>:346920: ERROR:
dtoi: integer out of range
From | Date | Subject | |
---|---|---|---|
Next Message | D.C. | 2005-05-13 18:27:34 | nope, still no history .. |
Previous Message | Stephan Szabo | 2005-05-13 14:20:45 | Re: [Fwd: Re: Trigger Procedures] |