type creates broken view, which can't be deleted

From: Charles Hornberger <charlie(at)k4azl(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: type creates broken view, which can't be deleted
Date: 1999-01-31 05:51:11
Message-ID: 3.0.5.32.19990130215111.009c35f0@k4azl.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

It looks like there's a bug that allows you to create views with columns of type unknown, and then prevents you from dropping the view/table.

alpha_2=> \i brokenview
CREATE VIEW article_contrib_info AS
SELECT ac.article_id,
p,firstname, -- TYPO HERE, USED COMMA INSTEAD OF PERIOD
p.lastname
FROM person p, article_contributor ac
WHERE ac.person_id = p.person_id;
NOTICE: create: attribute named "p" has an unknown type
NOTICE: unknown node tag 704 in OffsetVarNodes()
NOTICE: Node is: { IDENT "p" }
NOTICE: copyObject: don't know how to copy 704
CREATE
alpha_2=> \d article_contrib_info

Table = article_contrib_info
+----------------------------------+----------------------------------+-------+
| Field | Type | Length|
+----------------------------------+----------------------------------+-------+
| article_id | int4 | 4 |
| p | unknown | var |
| firstname | varchar() | 0 |
| lastname | varchar() | 0 |
+----------------------------------+----------------------------------+-------+

alpha_2=> drop view article_contrib_info;
ERROR: badly formatted planstring "IDENT "p" "...

alpha_2=> drop table article_contrib_info;
ERROR: badly formatted planstring "IDENT "p" "...

alpha_2=>

Has anyone else heard of this behavior? Is it a documented bug? Or am I missing something obvious about how to resolve this kind of problem?

Charlie

Browse pgsql-general by date

  From Date Subject
Next Message Adriaan Joubert 1999-01-31 09:14:39 Postgres on Alpha?
Previous Message Felix Morley Finch 1999-01-31 05:08:14 Question about Linux, threads, and Postgres