problems with dropped columns

From: "Damjan Pipan" <damjan(dot)pipan(at)siol(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: problems with dropped columns
Date: 2003-01-28 13:36:25
Message-ID: 014801c2c6d2$40caf5b0$c400a8c0@valhala
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hi!

I have following problem:
I have created a table with some fields, then I dropped last field (integer)
and added
one extra field (integer). Then I have created a function which returns
record of table
type. I have selected a record from table and returned it, but the values in
last
field are wrong (missing). It looks like that it takes the dropped field
instead of the last field.

Damjan

CREATE OR REPLACE FUNCTION damjan_test111(integer) RETURNS public.fk_test AS
'
DECLARE
rec fk_test%ROWTYPE;
siteid ALIAS FOR $1;
BEGIN
FOR rec IN SELECT * FROM public.fk_test WHERE
i = siteid LOOP
RETURN rec;
END LOOP;
END;
' LANGUAGE 'plpgsql';

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jason Hihn 2003-01-28 13:58:09 Re: Using RSYNC for replication?
Previous Message Ron 2003-01-28 13:19:55 Re: list server problems?

Browse pgsql-hackers by date

  From Date Subject
Next Message Justin Clift 2003-01-28 13:52:57 Has everyone else here seen the "new" Database Open Test Suite by IBM?
Previous Message Ron 2003-01-28 13:19:55 Re: list server problems?