type creates broken view, which can't be deleted

From: Charles Hornberger <hornberger(at)tabloid(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: type creates broken view, which can't be deleted
Date: 1999-01-31 09:25:00
Message-ID: 3.0.5.32.19990131012500.00aed5c0@tabloid.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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Herouth Maoz 1999-01-31 11:55:17 Re: [GENERAL] Re: Displaying Image BLOBs
Previous Message Adriaan Joubert 1999-01-31 09:14:39 Postgres on Alpha?