Problem with inserting: attribute 'extended_reason'

From: Wim <wdh(at)belbone(dot)be>
To: pgsql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Problem with inserting: attribute 'extended_reason'
Date: 2002-05-21 13:16:44
Message-ID: 3CEA48BC.7020902@belbone.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marin Dimitrov 2002-05-21 13:19:57 Re: Help..
Previous Message Arindam Haldar 2002-05-21 12:34:37 Re: want basic help with C

Browse pgsql-novice by date

  From Date Subject
Next Message Joel Burton 2002-05-21 13:38:38 Re: [NOVICE] Problem with inserting: attribute 'extended_reason'
Previous Message andre 2002-05-21 11:56:16 Re: Guarantee uniqueness of PGP key