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
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 |