Adding column breaks function with composite type argument

From: Jeff Eckermann <jeckermann(at)verio(dot)net>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Adding column breaks function with composite type argument
Date: 2001-05-08 17:03:39
Message-ID: 08CD1781F85AD4118E0800A0C9B8580B094A6D@NEZU
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I created a pl/pgsql function which takes a table row as an argument,
returning a value based on a comparison of two fields in each row.
This worked fine until I did an "ALTER TABLE ... ADD COLUMN ... ;",
whereupon the function failed to work, producing an error message : "ERROR:
query didn't return correct # of attributes for $1"
Dropping and recreating the function made no difference.
Rewriting the function to just take those two fields as arguments is no
biggie, but: why should this fail?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mikheev, Vadim 2001-05-08 18:11:52 RE: rserv
Previous Message Bruce Momjian 2001-05-08 16:40:49 Re: Minor documentation bug