type creates broken view, which can't be deleted
От | Charles Hornberger |
---|---|
Тема | type creates broken view, which can't be deleted |
Дата | |
Msg-id | 3.0.5.32.19990131012500.00aed5c0@tabloid.net обсуждение исходный текст |
Ответы |
Re: [GENERAL] type creates broken view, which can't be deleted
|
Список | 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 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 resolvethis kind of problem? Charlie
В списке pgsql-general по дате отправления: