Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-hackers by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group