Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-novice by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group