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

Re: pgAdmin III Reverse Engineered SQL for RULES

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: "[pgADMIN]" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: pgAdmin III Reverse Engineered SQL for RULES
Date: 2003-08-15 10:48:44
Message-ID: 3F3CBA8C.2020406@pse-consulting.de (view raw or flat)
Thread:
Lists: pgadmin-support
Dave Page wrote:

>  
>
>     -----Original Message-----
>     *From:* Donald Fraser [mailto:demolish(at)cwgsy(dot)net]
>     *Sent:* 15 August 2003 00:51
>     *To:* [pgADMIN]
>     *Subject:* [pgadmin-support] pgAdmin III Reverse Engineered SQL
>     for RULES
>
>      
>     Haven't checked the latest version.
>     Running pgAdmin III 0.8.0 devel 3rd Aug.
>      
>     Feature requests:
>     1)
>     The reverse engineered SQL code for RULES does not include the
>     *normal* commented out -- DROP RULE ...
>     Which I find very handy in most of the other reverse engineered
>     SQL code. 
>      
>
> Fixed. You can also now create DO INSTEAD NOTHING rules which were 
> previously only possible if you padded out the definition with a few 
> spaces or CRs. 
>
>      
>     2)
>     RULES are displayed as CREATE RULE .....
>     Slightly more convenient would be CREATE OR REPLACE RULE ....
>      
>
> Not sure about the best way to fix this. In 7.3, the definition from 
> PostgreSQL is run through some code to format it more nicely. We 
> technically could insert OR REPLACE in there, but I'm not overly happy 
> with solution. In 7.4, the definition comes straight from PostgreSQL.
>  
> Any thoughts Andreas?
>  

Um,
did you notice that I already fixed it nearly two hours ago including 
reply to the list?

Regards,
Andreas


> Regards, Dave.




In response to

pgadmin-support by date

Next:From: Andreas PflugDate: 2003-08-15 10:52:06
Subject: Re: pgAdmin III Reverse Engineered SQL for RULES
Previous:From: Dave PageDate: 2003-08-15 09:23:28
Subject: Re: pgAdmin III Reverse Engineered SQL for RULES

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