testdb=# drop rule skip_test; ERROR: parser: parse error at or near ";" at character 20 testdb=# \h drop rule Command: DROP RULE Description: remove a rewrite rule Syntax: DROP RULE name [, ...]
testdb=# drop rule skip_test on test_view; DROP RULE
First of all did you guys have to change the syntax in 7.3, and make it incompatible with all the existing sql code out there? :-(
I see that the rule names are no longer required to be globally unique... but still it would be nice if it could understand the old syntax and work the old way as long as there is only one matching rule...
Secondly, even if it has to be this way, it looks like the help entry is out of date...
Dima
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
