Help: Input Error Notice

Поиск
Список
Период
Сортировка
От McCormick, Bill
Тема Help: Input Error Notice
Дата
Msg-id ABEAB6B64DB04241B1CDBBE47447563E010BE26C@NITCMSX04.nitc.catholichealth.net
обсуждение исходный текст
Ответы Re: Help: Input Error Notice  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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@catholichealth.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


В списке pgsql-novice по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: [JDBC] Using PgSQL in high volume and throughput problem
Следующее
От: "Buddy Shearer"
Дата:
Сообщение: BAD SU operator at startup