Re: Pseudo modification of views and triggers

> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm(dot)poure(at)freesurf(dot)fr]
> Sent: 19 February 2002 19:28
> To: pgadmin-hackers(at)postgresql(dot)org
> Subject: [pgadmin-hackers] Pseudo modification of views and triggers
>
>
> Dear Dave,
>
> I implemented pseudo-modification of views based on the
> function example.
> Pseudo modifiation is carried by a simple DROP /CREATE in
> both cases. This
> was pretty easy : I just had to copy and adapt your code...

Cool, I'll review it shortly.

> This seems to work fine. I will do the same for triggers and
> commit tomorrow
> after testing.

OK.

> I enabled pseudo-modification features only for >= 7.3. IMHO
> this is better
> to avoid confusion (or we would get questions like "why can
> we modify views
> and not functions?" from 7.1 users).

Sounds reasonable.

> One question : why did you keep the .ddl compatibility with
> previous dll
> versions? It is not necessary as the .dll is loaded at every
> startup. No?

Because it avoids having to recompile pgAdmin and all the plugins *every*
time pgSchema is rebuilt to fix a minor bug. If you need to break
compatibility though, then it's not a problem.

Cheers, Dave.