Ticket #170 (closed bug: fixed)

Opened 22 months ago

Last modified 22 months ago

Quoted rule identifiers (schema name)

Reported by: sbremal@… Owned by: gleu
Priority: minor Milestone: 1.10.3
Component: pgadmin Version: 1.10
Keywords: browser sqlpane Cc:
Platform: all

Description

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 ...

Change History

Changed 22 months ago by gleu

  • status changed from new to closed
  • version changed from trunk to 1.10
  • resolution set to fixed
  • milestone set to 1.10.3

Fixed in r8281 and 8282.

Note: See TracTickets for help on using tickets.