Обсуждение: [pgAdmin III] #170: Quoted rule identifiers (schema name)
#170: Quoted rule identifiers (schema name) ---------------------------------+------------------------------------------ Reporter: sbremal@… | Owner: gleu Type: bug | Status: new Priority: minor | Milestone: Component: pgadmin | Version: trunk Keywords: browser sqlpane | Platform: all ---------------------------------+------------------------------------------ This is the copy of the script produced in the SQL editor window upon clicking on "CREATE script" for my rule with quoted identifiers: -- Rule: ""EMPLOYMENT_CONTRACT_ACCOUNTINGS_EDITOR_INSERT_RULE" ON ACCOUNTING."EMPLOYMENT_CONTRACT_ACCOUNTINGS_EDITOR"" -- DROP RULE "EMPLOYMENT_CONTRACT_ACCOUNTINGS_EDITOR_INSERT_RULE" ON ACCOUNTING."EMPLOYMENT_CONTRACT_ACCOUNTINGS_EDITOR"; CREATE OR REPLACE RULE "EMPLOYMENT_CONTRACT_ACCOUNTINGS_EDITOR_INSERT_RULE" AS ON INSERT TO "ACCOUNTING"."EMPLOYMENT_CONTRACT_ACCOUNTINGS_EDITOR" DO INSTEAD INSERT INTO ... What I miss: - the quotation mark around the schema qualifier in the "Rule: ..." and "DROP ..." lines - the schema qualifier in the "CREATE OR REPLACE ..." line The same for the view itself looks fine: -- View: "ACCOUNTING"."EMPLOYMENT_CONTRACT_ACCOUNTINGS_EDITOR" -- DROP VIEW "ACCOUNTING"."EMPLOYMENT_CONTRACT_ACCOUNTINGS_EDITOR"; CREATE OR REPLACE VIEW "ACCOUNTING"."EMPLOYMENT_CONTRACT_ACCOUNTINGS_EDITOR" AS ... -- Ticket URL: <http://code.pgadmin.org/trac/ticket/170> pgAdmin III <http://code.pgadmin.org/trac/> pgAdmin III
#170: Quoted rule identifiers (schema name) ----------------------------------+----------------------------------------- Reporter: sbremal@… | Owner: gleu Type: bug | Status: closed Priority: minor | Milestone: 1.10.3 Component: pgadmin | Version: 1.10 Resolution: fixed | Keywords: browser sqlpane Platform: all | ----------------------------------+----------------------------------------- Changes (by gleu): * status: new => closed * version: trunk => 1.10 * resolution: => fixed * milestone: => 1.10.3 Comment: Fixed in r8281 and 8282. -- Ticket URL: <http://code.pgadmin.org/trac/ticket/170#comment:1> pgAdmin III <http://code.pgadmin.org/trac/> pgAdmin III