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
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
