minor bug in pgAdmin3 when creating views

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

Browse pgadmin-support by date

  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