Re: [NOVICE] Problem with inserting: attribute 'extended_reason'

> -----Original Message-----
> From: pgsql-novice-owner(at)postgresql(dot)org
> [mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Wim
> Sent: Tuesday, May 21, 2002 9:17 AM
> To: pgsql-novice(at)postgresql(dot)org; pgsql-general(at)postgresql(dot)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(at)joelburton(dot)com | joelburton.com | aim: wjoelburton
Knowledge Management & Technology Consultant