Another bug with views

From: Dmitry Tkach <dmitry(at)openratings(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Another bug with views
Date: 2003-07-15 16:21:53
Message-ID: 3F142A21.7000802@openratings.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2003-07-15 16:40:38 Re: INSTEAD rule bug?
Previous Message Dmitry Tkach 2003-07-15 16:15:42 INSTEAD rule bug?