The following bug has been logged online:

Bug reference: 2572
Logged by: Emil J.
Email address: emilj (AT) pyton (DOT) sk
PostgreSQL version: 8.1.4
Operating system: Windows XP
Description: ALTER TABLE ADD COLUMN
Details:

I create some function (PLPGSQL):

......
BEGIN
ALTER TABLE sch.table ADD COLUMN abc INTEGER;
RETURN NULL;
END;

After i called it, nothing happend. No Error, No Exception, No effect - no
column added.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

On Sat, Aug 12, 2006 at 11:53:08AM +0000, Emil J. wrote:
Works here. Is it possible that the calling transaction rolled
back or that it hadn't committed yet and you looked at the table
in another transaction? Can you provide a complete test case?

Example:

test=> CREATE TABLE foo (id integer);
CREATE TABLE
test=> CREATE FUNCTION test() RETURNS void AS $$
test$> BEGIN
test$> ALTER TABLE foo ADD COLUMN newcol integer;
test$> END;
test$> $$ LANGUAGE plpgsql;
CREATE FUNCTION
test=> \d foo
Table "public.foo"
Column | Type | Modifiers
--------+---------+-----------
id | integer |

test=> SELECT test();
test
------

(1 row)

test=> \d foo
Table "public.foo"
Column | Type | Modifiers
--------+---------+-----------
id | integer |
newcol | integer |

--
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org