Re: ALTER VIEW

2002-02-23 Thread Dave Page
> -Original Message- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]] > Sent: 23 February 2002 18:30 > To: Dave Page > Cc: [EMAIL PROTECTED] > Subject: Re: [pgadmin-hackers] ALTER VIEW > > > > > 4) A class library such as this should _never_ disp

Re: ALTER VIEW

2002-02-23 Thread Jean-Michel POURE
Hi Dave, I commited some changes to CVS. Now, I need more info to understand : A. VIEWS > 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. Done. > 2) The szOldDefintion stuff can now be removed. Do

Re: ALTER VIEW

2002-02-22 Thread Dave Page
> -Original Message- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]] > Sent: 22 February 2002 22:11 > To: Dave Page; [EMAIL PROTECTED] > Subject: Re: ALTER VIEW > > > Le Vendredi 22 Février 2002 23:06, Dave Page a écrit : > > > 5) The modificati

Re: ALTER VIEW

2002-02-22 Thread Jean-Michel POURE
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

ALTER VIEW

2002-02-22 Thread Dave Page
Hi Jean-Michel, I just took a look at the latest ALTER VIEW code. Sorry, but I have a number of problems with this version: 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. 2) The szOl

Re: ALTER VIEW

2002-02-20 Thread Dave Page
> -Original Message- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]] > Sent: 20 February 2002 09:37 > To: Dave Page > Cc: [EMAIL PROTECTED] > Subject: Re: ALTER VIEW > > > Le Mercredi 20 Février 2002 10:27, Dave Page a écrit : > > I just not

Re: ALTER VIEW

2002-02-20 Thread Jean-Michel POURE
Le Mercredi 20 Février 2002 10:27, Dave Page a écrit : > I just noticed in your update you forgot to alter the pgView.SQL function > entry iLogEvent call to log the new parameters; It should look like: > > Public Property Get SQL(Optional PseudoAlter As Boolean) As String > On Error GoTo Err_Handl