Re: Bug in ALTER COLUMN/TYPE

From: Rod Taylor <rbt(at)sitesell(dot)com>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Bug in ALTER COLUMN/TYPE
Date: 2004-08-04 14:14:21
Message-ID: 1091628860.58593.65.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 2004-08-03 at 23:36, Christopher Kings-Lynne wrote:
> I think we need to deny changing column types if a function is using the
> table type as a return set.
>
> test=# create table test (a int4);
> CREATE TABLE
> test=# create function test () returns setof test as 'select 1' language
> sql;

What we really need is dependencies within the function body and the
ability to clear the function cache (recompile).

--
rbt <at> sitesell <dot> com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message chinni 2004-08-04 14:20:09 postgres and Jdbc 2.0
Previous Message Tom Lane 2004-08-04 13:54:11 Re: Bug in ALTER COLUMN/TYPE