Re: Pseudo modification of views and triggers - Mailing list pgadmin-hackers

From Dave Page
Subject Re: Pseudo modification of views and triggers
Date
Msg-id FED2B709E3270E4B903EB0175A49BCB10475B9@dogbert.vale-housing.co.uk
Whole thread Raw
In response to Pseudo modification of views and triggers  (Jean-Michel POURE <jm.poure@freesurf.fr>)
List pgadmin-hackers

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

pgadmin-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: [GENERAL] MDB 2 POSTGRESQL MIGRATION PROBLE
Next
From: Dave Page
Date:
Subject: Re: Pseudo modification of views and triggers (again)