From: | Terence Kearns <terencek(at)isd(dot)canberra(dot)edu(dot)au> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | minor bug in pgAdmin3 when creating views |
Date: | 2003-07-16 08:52:28 |
Message-ID: | 3F15124C.7000703@cts.canberra.edu.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
When attempting to create a view with the comment box populated,
pgAdmin3 generated the following SQL
CREATE OR REPLACE VIEW global.v_db_classes AS
select type_id AS db_class_id, title AS db_class
from global.types
where cat = 'dbClasses';
COMMENT ON TABLE global.v_db_classes IS 'This pseudo entity is based on
the types table and contains a list of entities in the database';
The problem is that in the COMMENT ON statement, said view is now
referred to as a TABLE instead of a VIEW. This produced the appropriate
error. The work-around was to simply copy/paste it into an SQL execution
window and modify the COMMENT ON statement.
--
Terence Kearns ~ ph: +61 2 6201 5516
IT Database/Applications Developer
Enterprise Information Systems
Client Services Division
University of Canberra
www.canberra.edu.au
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2003-07-16 08:58:52 | Re: pgAdmin3: adding comments to existing tables |
Previous Message | D Tim Cummings | 2003-07-16 08:21:04 | Re: Migration Wizard - Access 97 Autonumber |