Skip site navigation (1) Skip section navigation (2)

Pseudo modification of views and triggers

From: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Pseudo modification of views and triggers
Date: 2002-02-19 19:28:27
Message-ID: 200202191928.g1JJSRFP019743@www1.translationforge (view raw or flat)
Thread:
Lists: pgadmin-hackers
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


pgadmin-hackers by date

Next:From: Mark A. TaffDate: 2002-02-19 19:50:08
Subject: controls
Previous:From: Dave PageDate: 2002-02-19 17:14:24
Subject: Re: Broken sql string?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group