Re: [GENERAL] type creates broken view, which can't be deleted - Mailing list pgsql-general

From Bruce Momjian
Subject Re: [GENERAL] type creates broken view, which can't be deleted
Date
Msg-id 199902021913.OAA06794@candle.pha.pa.us
Whole thread Raw
In response to type creates broken view, which can't be deleted  (Charles Hornberger <hornberger@tabloid.net>)
List 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
droppingthe 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

I couldn't recreate it in the current source tree:

    create view xxy as select p, relname from pg_class;


--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: "Jackson, DeJuan"
Date:
Subject: RE: [GENERAL] How can I call a function to return a code fragemen tfrom within a pg_Exec
Next
From: "Jackson, DeJuan"
Date:
Subject: RE: [GENERAL] Missing features ?