Skip site navigation (1) Skip section navigation (2)

Re: plpgsql function error after alter table add

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Tim Dunnington <timbert(at)timshouse(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: plpgsql function error after alter table add
Date: 2000-12-13 00:21:06
Message-ID: 3A36C0F2.A52DB121@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-bugs
Tom Lane wrote:
> 
> "Tim Dunnington" <timbert(at)timshouse(dot)com> writes:
> > If you create a function with a table as the argument, and later alter that
> > table and add a new column, the function fails saying "incorrect number of
> > attributes for table _tablename_"  Dropping and readding the function does
> > not fix this problem.
> 
> I think this is not so much a plpgsql bug as a side effect of the rather
> shoddy implementation of ALTER TABLE ADD COLUMN. 

Seems a plpgsql's simple bug.

> It doesn't go through
> and alter any actual tuples in the table, it just adds the column to the
> schema.

It seems a nice implementation.

Regards.
Hiroshi Inoue

In response to

pgsql-bugs by date

Next:From: Peter EisentrautDate: 2000-12-13 19:09:17
Subject: Re: Solaris ODBC - linker flag needs to be set when building shared objects
Previous:From: Tom LaneDate: 2000-12-12 21:14:21
Subject: Re: plpgsql function error after alter table add

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group