From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | sbremal(at)hotmail(dot)com |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Quoted rule identifiers (schema name) |
Date: | 2010-04-19 22:03:07 |
Message-ID: | 4BCCD31B.4010307@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hi,
Le 19/04/2010 17:31, sbremal(at)hotmail(dot)com a écrit :
> [...]
> 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
OK, this will be simple to do. I'll add a ticket and work on this tomorrow.
> - the schema qualifier in the "CREATE OR REPLACE ..." line
>
The CREATE OR REPLACE line seems good to me. Can you tell me what you
already have and what you want? Thanks.
> 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 ...
>
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2010-04-19 22:04:38 | Re: Pgadmin3 - CentOS 5 - Missing Dependency: libpq.so.5 |
Previous Message | Jorge Gustavo Rocha | 2010-04-19 19:01:03 | Ctrl+V Hot key defined twice |