Ticket #170 (closed bug: fixed)
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 ...
