Re: Bug in renaming view columns

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Bug in renaming view columns
Date: 2004-05-11 00:10:50
Message-ID: 40A01A0A.7070501@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Take it a little further: if we extend ALTER TABLE to be able to alter
> view column types, would you expect CREATE OR REPLACE VIEW to stop
> checking that the column types didn't change? I'd argue that that's a
> real bad idea. If you want the view's output signature to change, you
> should have to use a command that indicates that's your intent.

Sounds reasonable. I was just wondering if renaming columns with ALTER
TABLE was intentional...

Chris

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Gaetano Mendola 2004-05-11 00:50:16 tinyint
Previous Message Gaetano Mendola 2004-05-10 23:26:21 Re: email built in type