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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2000-12-13 19:09:17 | Re: Solaris ODBC - linker flag needs to be set when building shared objects |
Previous Message | Tom Lane | 2000-12-12 21:14:21 | Re: plpgsql function error after alter table add |