Re: Adding column breaks function with composite type argument - Mailing list pgsql-general

From Tom Lane
Subject Re: Adding column breaks function with composite type argument
Date
Msg-id 8040.989353844@sss.pgh.pa.us
Whole thread Raw
In response to Adding column breaks function with composite type argument  (Jeff Eckermann <jeckermann@verio.net>)
List pgsql-general
Jeff Eckermann <jeckermann@verio.net> writes:
> 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"

Fixed in 7.1.1.

            regards, tom lane

pgsql-general by date:

Previous
From: Kyle
Date:
Subject: Re: poor performance on 7.1 vs 7.0
Next
From: Tom Lane
Date:
Subject: Re: select off of a view going slowly