Another bug with views - Mailing list pgsql-bugs

From Dmitry Tkach
Subject Another bug with views
Date
Msg-id 3F142A21.7000802@openratings.com
Whole thread Raw
Responses Re: Another bug with views  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
... and here is another bug I ran into while trying to investigate my
earlier problem with views a little more:

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

pgsql-bugs by date:

Previous
From: Dmitry Tkach
Date:
Subject: INSTEAD rule bug?
Next
From: Tom Lane
Date:
Subject: Re: INSTEAD rule bug?