problems with dropped columns

Поиск
Список
Период
Сортировка
От Damjan Pipan
Тема problems with dropped columns
Дата
Msg-id 014801c2c6d2$40caf5b0$c400a8c0@valhala
обсуждение исходный текст
Ответ на list server problems?  (Martin Kutschker <Martin.Kutschker@blackbox.net>)
Список pgsql-general
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';


В списке pgsql-general по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: list server problems?
Следующее
От: Jason Hihn
Дата:
Сообщение: Re: Using RSYNC for replication?