ERROR: invalid input syntax for integer: ""

From: Rakotomandimby Mihamina <mihamina(at)gulfsat(dot)mg>
To: pgsql-general(at)postgresql(dot)org
Subject: ERROR: invalid input syntax for integer: ""
Date: 2009-09-25 10:49:32
Message-ID: 4ABCA03C.1070307@gulfsat.mg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,
I get invalid input syntax when UPDATEing my radacct table:

freedsl=# \d radacct
Table "public.radacct"
Column | Type | Modifiers
----------------------+--------------------------+-------------------------------------------------------------
radacctid | bigint | not null default nextval('radacct_radacctid_seq'::regclass)
acctsessionid | character varying(32) | not null
acctuniqueid | character varying(32) | not null
username | character varying(253) |
groupname | character varying(253) |
realm | character varying(64) |
nasipaddress | inet | not null
nasportid | character varying(15) |
nasporttype | character varying(32) |
acctstarttime | timestamp with time zone |
acctstoptime | timestamp with time zone |
acctsessiontime | bigint |
acctauthentic | character varying(32) |
connectinfo_start | character varying(50) |
connectinfo_stop | character varying(50) |
acctinputoctets | bigint |
acctoutputoctets | bigint |
calledstationid | character varying(50) |
callingstationid | character varying(50) |
acctterminatecause | character varying(32) |
servicetype | character varying(32) |
xascendsessionsvrkey | character varying(10) |
framedprotocol | character varying(32) |
framedipaddress | inet |
acctstartdelay | integer |
acctstopdelay | integer |
Indexes:
"radacct_pkey" PRIMARY KEY, btree (radacctid)

The query is:

UPDATE radacct
SET
AcctStopTime = ('2009-09-25 10:35:44'::timestamp - '0'::interval),
AcctSessionTime = CASE WHEN '' = '' THEN (EXTRACT(EPOCH FROM ('2009-09-25 10:35:44'::TIMESTAMP WITH TIME ZONE - AcctStartTime::TIMESTAMP WITH TIME ZONE - '0'::INTERVAL)))::BIGINT ELSE '' END,
AcctInputOctets = (('0'::bigint << 32) + '0'::bigint),
AcctOutputOctets = (('0'::bigint << 32) + '0'::bigint),
AcctTerminateCause = '',
AcctStopDelay = 0,
FramedIPAddress = NULLIF('', '')::inet,
ConnectInfo_stop = ''
WHERE AcctSessionId = ''
AND UserName = 'mihamina'
AND NASIPAddress = '0.0.0.0'
AND AcctStopTime IS NULL

I cannot find the problem....
Any hints?
Thank you.

--
Architecte Informatique chez Blueline/Gulfsat:
Administration Systeme, Recherche & Developpement
+261 34 29 155 34

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2009-09-25 10:55:36 Re: ERROR: invalid input syntax for integer: ""
Previous Message S Arvind 2009-09-25 09:30:08 Re: About logging