pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Justin Clift <aa2@bigpond.net.au>
To: PostgreSQL SQL Mailing list <pgsql-sql@postgresql.org>
Subject: Re: Help needed -> ERROR:  record arow has no field description
Date: Thu, 01 Mar 2001 15:21:11 +1100
Message-ID: <3A9DCE37.C6C25F5@bigpond.net.au> (raw)
References: <3A9DAD09.E1FBBA50@bigpond.net.au>

Hi all,

Solved my own problem.  I was just misreading the error message.  It was
actually TELLING me the problem (I was referencing a table with no field
called "description" in the select, but trying to use it in the loop.

Sorry for disturbing people.

As an aside, this has motivated me to add a section on error messages
into techdocs.postgresql.org (very messy at the moment, I'll fix it
tonight).

Regards and best wishes,

+ Justin Clift
Database Administrator

Justin Clift wrote:
> 
> Hi all,
> 
> I'm getting this error, which to me makes no sense.  Running PostgreSQL
> 7.0.3 on Mandrake 7.2 (compiled from source, not the rpms).
> 
> The code is in a pl/pgsql function I am writing and I can't see why it's
> complaining.
> 
> This is the appropriate part of the code :
> 
> <general CREATE type header>
> 
>         arow            record;
> 
>         <other declarations>
> 
>         BEGIN
> 
>         <other code here, which works>
> 
>         FOR arow IN select transaction_payments.cashback from
> transaction_payments, payment_types where
>          transaction_payments.payment_type = payment_types.idnum LOOP
>             textbuf := text(arow.cashback);
>             textbuf := textcat(textbuf, ''  '');
>             insert into receipts (receipt_num, data) values (trans_num,
> textbuf);
>         END LOOP;
> 
> <general END type syntax>
> 
> >From the PostgreSQL log file (debug is set to 2), I am getting :
> 
> query: SELECT  transaction_payments.cashback from transaction_payments,
> payment_types where transaction_payments.payment_type =
> payment_types.idnum
> ERROR:  record arow has no field description
> DEBUG:  Last error occured while executing PL/pgSQL function
> create_receiptp3
> DEBUG:  line 105 at assignment
> AbortCurrentTransaction
> 
> The "arow" record type variable is used quite a lot in previous FOR
> loops in this function.  This is the first FOR loop in the function that
> uses more than one table though.  I suspect this may have something to
> do with it.
> 
> As far as I can tell, this SQL statement is valid.  Does anyone have any
> ideas how to get this to work.  I have tried several variations, and the
> mailing lists don't even have a reference for this error message.
> 
> Regards and best wishes,
> 
> Justin Clift
> Database Administrator



view thread (3+ messages)  latest in thread

Message-ID: <3A9DCE37.C6C25F5@bigpond.net.au>
Permalink:  ../3A9DCE37.C6C25F5@bigpond.net.au/
Also on:    postgresql.org/message-id/3A9DCE37.C6C25F5@bigpond.net.au

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: aa2@bigpond.net.au
  Subject: Re: Help needed -> ERROR:  record arow has no field description
  In-Reply-To: <3A9DCE37.C6C25F5@bigpond.net.au>
  References: <3A9DAD09.E1FBBA50@bigpond.net.au> <3A9DCE37.C6C25F5@bigpond.net.au>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox