Thread: Problem with inserting: attribute 'extended_reason'

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

> -----Original Message-----
> From: pgsql-novice-owner@postgresql.org
> [mailto:pgsql-novice-owner@postgresql.org]On Behalf Of Wim
> Sent: Tuesday, May 21, 2002 9:17 AM
> To: pgsql-novice@postgresql.org; pgsql-general@postgresql.org
> Subject: [NOVICE] Problem with inserting: attribute 'extended_reason'
>
>
> Hi all,
>
>
> In a perl script I try to insert a row with the follow SQL command:
>
> 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?

Table "billing" does not have field "extended_reason".

In psql, use "\d billing" to see a list of fields in the table. Perhaps you
called it something else.

- J.

Joel BURTON | joel@joelburton.com | joelburton.com | aim: wjoelburton
Knowledge Management & Technology Consultant