[pgAdmin III] #167: Missing RULEs for VIEWs in SQL pane

#167: Missing RULEs for VIEWs in SQL pane
----------------------+-----------------------------------------------------
Reporter: brsa | Owner: dpage
Type: bug | Status: new
Priority: minor | Milestone:
Component: pgadmin | Version: trunk
Keywords: SQL pane | Platform: all
----------------------+-----------------------------------------------------
SQL pane:
RULEs are added to the SQL of TABLEs, but they are missing with VIEWs.
That is inconsistent at the least. If the general guideline is: the
displayed SQL shall be able to recreate an identical object (or so is my
understanding, at least with identical settings), it's a bug.
Demo:
-- TABLE --
-- i say --
CREATE TABLE test (id integer);
CREATE TABLE test2 (id integer);

CREATE RULE on_delete AS
ON DELETE
TO test
DO INSTEAD
DELETE FROM test2
WHERE test2.id = old.id;

-- pgadmin says --
-- Table: test

-- DROP TABLE test;

CREATE TABLE test
(
id integer
)
WITH (
OIDS=FALSE
);
ALTER TABLE test OWNER TO postgres;

-- Rule: "on_delete ON test"

-- DROP RULE on_delete ON test;

CREATE OR REPLACE RULE on_delete AS
ON DELETE TO test DO INSTEAD DELETE FROM test2
WHERE test2.id = old.id;
-- note the attached RULE
[[br]]

-- VIEW --
-- I say --
CREATE VIEW v_test AS
SELECT * FROM test;

CREATE RULE on_delete AS
ON DELETE
TO v_test
DO INSTEAD
DELETE FROM test2
WHERE test2.id = old.id;

-- pgadmin says --
CREATE OR REPLACE VIEW v_test AS
SELECT test.id
FROM test;
(...)
-- note the missing RULE!

--
Ticket URL: <http://code.pgadmin.org/trac/ticket/167>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III