Skip site navigation (1) Skip section navigation (2)

[pgAdmin III] #170: Quoted rule identifiers (schema name)

From: "pgAdmin Trac" <trac(at)code(dot)pgadmin(dot)org>
To:
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: [pgAdmin III] #170: Quoted rule identifiers (schema name)
Date: 2010-04-20 17:03:17
Message-ID: 060.e169f6938d404099590c398b5e32ece5@code.pgadmin.org (view raw or flat)
Thread:
Lists: pgadmin-hackers
#170: Quoted rule identifiers (schema name)
---------------------------------+------------------------------------------
 Reporter:  sbremal(at)…            |       Owner:  gleu 
     Type:  bug                  |      Status:  new  
 Priority:  minor                |   Milestone:       
Component:  pgadmin              |     Version:  trunk
 Keywords:  browser sqlpane      |    Platform:  all  
---------------------------------+------------------------------------------
 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 ...

-- 
Ticket URL: <http://code.pgadmin.org/trac/ticket/170>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III

Responses

pgadmin-hackers by date

Next:From: svnDate: 2010-04-20 17:07:03
Subject: SVN Commit by guillaume: r8281 - in branches/REL-1_10_0_PATCHES/pgadmin3: . pgadmin/schema
Previous:From: svnDate: 2010-04-20 16:33:37
Subject: SVN Commit by guillaume: r8280 - branches/REL-1_10_0_PATCHES/pgadmin3/i18n/pt_PT

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group