From: | <sbremal(at)hotmail(dot)com> |
---|---|
To: | <pgadmin-support(at)postgresql(dot)org> |
Subject: | Quoted rule identifiers (schema name) |
Date: | 2010-04-19 15:31:10 |
Message-ID: | SNT127-W646FEF88971E1E3B334E2DA90B0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hello,
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 ...
Regards,
B.
_________________________________________________________________
Hotmail: Free, trusted and rich email service.
https://signup.live.com/signup.aspx?id=60969
From | Date | Subject | |
---|---|---|---|
Next Message | António Santos (DOS) | 2010-04-19 16:10:53 | Pgadmin3 - CentOS 5 - Missing Dependency: libpq.so.5 |
Previous Message | Guillaume Lelarge | 2010-04-16 21:09:03 | Re: Bug: recent files reset |