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
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
