Skip site navigation (1) Skip section navigation (2)

Re: ALTER VIEW

From: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>,pgadmin-hackers(at)postgresql(dot)org
Subject: Re: ALTER VIEW
Date: 2002-02-22 22:11:21
Message-ID: 200202222211.g1MMBLFP014764@www1.translationforge (view raw or flat)
Thread:
Lists: pgadmin-hackers
Le Vendredi 22 Février 2002 23:06, Dave Page a écrit :
> 1) Don't create the view twice, create the fake one then rename it - it's
> less expensive and avoids the potential for the second create to fail.
OK

> 2) The szOldDefintion stuff can now be removed.
OK

> 3) The OID and Definition could be retrieved in one operation rather than
> 2.
OK

> 4) A class library such as this should _never_ display any user interface.
> That is the job of the application.
OK

> 5) The modifications to the SQL property are messy & mainly unnecessary
> (certainly with #1 above - that just needs bDrop & szViewName).
Will have a look at it tomorrow. I though interesting to write SQL using a 
single property. This is easier to maintain code. Don't flame me...

> 6) The iLogEvent "Entering..." code should be immediately after the On
> Error code, not in the middle of the function.
OK

> 7) The Comment cache is not being invalidated.
OK

\Later

In response to

  • ALTER VIEW at 2002-02-22 22:06:52 from Dave Page

pgadmin-hackers by date

Next:From: Dave PageDate: 2002-02-22 22:15:27
Subject: Re: Triggers
Previous:From: Dave PageDate: 2002-02-22 22:06:52
Subject: ALTER VIEW

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group