Re: pgAdmin III Reverse Engineered SQL for RULES

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.