create or replace view

From: snpe <snpe(at)snpe(dot)co(dot)yu>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: create or replace view
Date: 2002-11-14 13:41:18
Message-ID: 200211141341.18164.snpe@snpe.co.yu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,
When I change view and change number of column PostgreSQL return error :
'cannot change number of column in view'
Is it too hard set this command
if view exits drop view
and then change view

It is like with return type in function

Now 'or replace' don't help too much

regards

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-11-14 13:57:16 Re: Does v7.2.x support AIX 5.1?
Previous Message snpe 2002-11-14 13:31:11 Re: [JDBC] [HACKERS] PostgreSQL JDBC and sub-select