Re: [GENERAL] problems with dropped columns

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Damjan Pipan" <damjan(dot)pipan(at)siol(dot)net>,<pgsql-general(at)postgresql(dot)org>,"Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [GENERAL] problems with dropped columns
Date: 2003-03-06 02:21:36
Message-ID: 02e801c2e387$1e2163b0$6500a8c0@fhp.internal
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-general pgsql-hackers

I want to fix this bug, however I can't see how the example below is
failing... (Obeys dropped columns) I'm not up with my SRFs, so would
someone be able to post a concise SQL script that demonstrates the failure?

I can see in the code that it should be failing, but I need a demonstrated
example...

Chris

----- Original Message -----
From: "Damjan Pipan" <damjan(dot)pipan(at)siol(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, January 28, 2003 9:36 PM
Subject: [GENERAL] problems with dropped columns

> 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';
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-03-06 02:30:28 Re: [PATCHES] Non-colliding auto generated names
Previous Message cbbrowne 2003-03-06 02:10:33 Re: XML ouput for psql

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2003-03-06 02:26:12 Re: Where are the current install instructions?
Previous Message Tony Grant 2003-03-06 01:59:05 Re: a date_part question