Re: empty view, replace view, column type change?

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: PgSQL - SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: empty view, replace view, column type change?
Date: 2005-06-23 20:21:58
Message-ID: 1119558118.7430.19.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Dnia 23-06-2005, czw o godzinie 22:03 +0200, Markus Bertheau napisał(a):
> Hi,
>
> it seems to me that the following should work but it fails:
>
> CREATE VIEW co AS SELECT LOCALTIMESTAMP::TIMESTAMP AS ov WHERE FALSE;
> CREATE TABLE link (ov TIMESTAMP);
> CREATE OR REPLACE VIEW co AS SELECT ov FROM link;

Erm, the error message is something to the effect of

ERROR: can't change type of view column "ov"

--
Markus Bertheau <twanger(at)bluetwanger(dot)de>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Rod Taylor 2005-06-23 20:26:51 Re: empty view, replace view, column type change?
Previous Message Rod Taylor 2005-06-23 20:19:44 Re: empty view, replace view, column type change?