Quoted rule identifiers (schema name)
От | |
---|---|
Тема | Quoted rule identifiers (schema name) |
Дата | |
Msg-id | SNT127-W646FEF88971E1E3B334E2DA90B0@phx.gbl обсуждение исходный текст |
Ответы |
Re: Quoted rule identifiers (schema name)
|
Список | 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 quotedidentifiers: -- 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
В списке pgadmin-support по дате отправления: