Thread: Pseudo modification of views and triggers

Pseudo modification of views and triggers

From
Jean-Michel POURE
Date:
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...

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

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).

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?

Cheers,
Jean-Michel


Re: Pseudo modification of views and triggers

From
Dave Page
Date:

> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm.poure@freesurf.fr]
> Sent: 19 February 2002 19:28
> To: pgadmin-hackers@postgresql.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.