| From: | snpe <snpe(at)snpe(dot)co(dot)yu> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: create or replace view |
| Date: | 2002-11-15 02:09:13 |
| Message-ID: | 200211150209.13246.snpe@snpe.co.yu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thursday 14 November 2002 10:36 pm, Stephan Szabo wrote:
> On Thu, 14 Nov 2002, snpe wrote:
> > Problem is when I want change view (or functions) with a lot of
> > dependecies I must drop and recreate all dependent views (or functions) -
> > I want add only one column in view
> > I don't know if solution hard for that.
>
> Well, doing create or replace as a drop/create might very well do the same
> thing, and even if it got the same oid, we'd have to be really sure that
> nothing would misbehave upon receiving that extra column before allowing
> it for purposes of avoiding recreation of dependencies.
>
>
Can PostgreSQL recreate dependecies automaticly or say 'object is not valid'
regards
Haris Peco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2002-11-15 02:14:55 | Re: create or replace view |
| Previous Message | Bruce Momjian | 2002-11-15 01:52:10 | Re: FW: PostgreSQL 7.3 Platform Testing |