Problem with inserting: attribute 'extended_reason'
От | Wim |
---|---|
Тема | Problem with inserting: attribute 'extended_reason' |
Дата | |
Msg-id | 3CEA48BC.7020902@belbone.be обсуждение исходный текст |
Ответы |
Re: [NOVICE] Problem with inserting: attribute 'extended_reason'
|
Список | pgsql-general |
Hi all, In a perl script I try to insert a row with the follow SQL command: INSERT INTO billing ( pin, start_time, duration, service_code, phone_number, ip_address_ingress, ip_address_egress, call_id, service_type, is_free, bill_type, source_gateway_id, dest_gateway_id, disconnect_reason, extended_reason, total_units, dnis, ani, dept_ref_no, port_number, sub_net_id, originating_net_id, destination_net_id, total_time, seq_no, new_call_id, rating_string, start_access_time, billing_result, domain, version, remote_domain, stat0, stat1, stat2, stat3, stat4, stat5, stat6, stat7, stat8, stat9, subscriber_id, ii_digits, ip_addr_proxy, total_units_2, pin_2, source_call_control_id, dest_call_control_id) VALUES ('1313', '2002-05-21 15:05:14', '0', 'C', '673-8-819797', '195.13.13.22', '203.208.158.69', '0', '', 'N', 'I', '6006', '-1', 'CR', '61', '0', '6738819797', '', '', '0', '1109', '1109' '1096', '35', '', '109611100000000000014982419', '', '2002-05-21 15:05:14', '1000', '32__124VS2B8', '3.2.1224.7', '65__1E1VS2BC', '0', '1113', '0', '0', '0', '0', '0', '0', '0', '0', '100010022', '', '', '0', 'GPVPIN', '-1', '-1', 'G723High') What Perl returns is: DBD::Pg::st execute failed: ERROR: Relation 'billing' does not have attribute 'extended_reason' at ./upd_billing.pl line 147, <BILLINGFILE> line 241. Does anyone of you knows what this means? Thanx! Wim
В списке pgsql-general по дате отправления: