BUG #5078: returns setof functions fails after table structure altered

From: "Sergey Manakov" <vialorn(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5078: returns setof functions fails after table structure altered
Date: 2009-09-24 09:05:59
Message-ID: 200909240905.n8O95x4G095719@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5078
Logged by: Sergey Manakov
Email address: vialorn(at)gmail(dot)com
PostgreSQL version: 8.4.1
Operating system: Fedora Core 11
Description: returns setof functions fails after table structure
altered
Details:

Hi! I'am from Russia and write English ugly, but i'am must to try...

Just repeat steps below:

CREATE TABLE biz_uks
(
id serial NOT NULL,
rid timestamp(0) without time zone NOT NULL DEFAULT
('now'::text)::timestamp without time zone,
title character varying NOT NULL,
otitles character varying,
adrfact character varying NOT NULL,
station character varying,
region integer,
zipcode character varying,
phone character varying NOT NULL,
fax character varying,
url character varying,
mail character varying,
techabout text,
remark character varying,
cnlastdate date,
CONSTRAINT pk_biz_uks PRIMARY KEY (id),
CONSTRAINT uq_biz_uks UNIQUE (title)
);
COMMENT ON TABLE biz_uks IS 'Справочник управляющих
компаний';

alter table biz_uks
drop column remark
;

drop function if exists set__biz_uks();
create or replace function set__biz_uks()
returns biz_uks
security definer volatile language plpgsql as $$
declare
res biz_uks;
begin
return res;
end;
$$ ;
select * from set__biz_uks();

drop function if exists set__biz_uks();
create or replace function set__biz_uks()
returns setof biz_uks
security definer volatile language plpgsql as $$
declare
res biz_uks;
begin
return query
select res.*;
end;
$$ ;
select * from set__biz_uks();

Last command will raise exception!

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Massimiliano Ziccardi 2009-09-24 10:56:33 Porblem running on Windows 2003 server
Previous Message Richard Neill 2009-09-24 06:13:55 Postgresql 8.4.1 segfault, backtrace