Re: fake vs real CREATE OR REPLACE VIEW

> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm(dot)poure(at)freesurf(dot)fr]
> Sent: 26 February 2002 08:09
> To: pgadmin-hackers(at)postgresql(dot)org
> Subject: [pgadmin-hackers] fake vs real CREATE OR REPLACE VIEW
>
>
> Dear Dave,
>
> + create "view_a" querying "view_b",
> + alter "view_b",
> = "view_a "is broken because "view_b" changed OIDs.

Yes. I thought I suggested adding a warning to that effect at one time.

> This to say we really need CREATE OR REPLACE VIEW in
> PostgreSQL. Do you
> remember the email of the developper who proposed to add this
> feature to
> PostgreSQL? Could you contact him off the list to ask if this
> is still on his
> agenda?

It was Gavin Sherry I think, but I'm not going to hassle him about it, he
specifically said he wasn't going to do it immediately.

How's the ALTER VIEW patch coming along btw?

Regards, Dave.