Re: ALTER VIEW - Mailing list pgadmin-hackers

From Jean-Michel POURE
Subject Re: ALTER VIEW
Date
Msg-id 200202222211.g1MMBLFP014764@www1.translationforge
Whole thread Raw
In response to ALTER VIEW  (Dave Page <dpage@vale-housing.co.uk>)
List 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

pgadmin-hackers by date:

Previous
From: Jean-Michel POURE
Date:
Subject: Triggers
Next
From: Dave Page
Date:
Subject: Re: ALTER VIEW