[pgAdmin III] #167: Missing RULEs for VIEWs in SQL pane - Mailing list pgadmin-hackers

#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