Re: Quoted rule identifiers (schema name)

Le 20/04/2010 00:03, Guillaume Lelarge a écrit :
> Hi,
> 
> Le 19/04/2010 17:31, sbremal@hotmail.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
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
> 
> OK, this will be simple to do. I'll add a ticket and work on this tomorrow.
> 

Done (http://code.pgadmin.org/trac/ticket/170), and fix commited.


-- 
Guillaume.http://www.postgresqlfr.orghttp://dalibo.com