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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | svn | 2010-04-20 17:07:03 | SVN Commit by guillaume: r8281 - in branches/REL-1_10_0_PATCHES/pgadmin3: . pgadmin/schema |
Previous Message | svn | 2010-04-20 16:33:37 | SVN Commit by guillaume: r8280 - branches/REL-1_10_0_PATCHES/pgadmin3/i18n/pt_PT |